Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Thanh_MA
Frequent Visitor

Calculating number of customer appearances by year

Hi All

 

I have a following solution

 

 i use the distinct count of the user by year if they have the project with my company , i mean if this year they have  project , i still count 1 time, anyway to calculate column total to see how many times this user occur following year (sush as, the user name ABB, i work with them in 2020 and 2021, mean 2 times