Calculating number of customer appearances by year

[Thanh_MA]

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

[Thanh_MA]

Hi @v-xiaosun-msft 

Thank you for your solution, but the problem is :

In my data, ABB showing 2 times in both 2020 and 2021, i just one if in 2020 even 10 times ABB showing , it just count 1 times, that mean  i want to show that in 2020 i did working with ABB only ( i dont care how many times in that year)

ABB in 2020 ,2 times: i want count 1
        in 2021, 2 times or what it is i still want count 1

Anyway to do this

Many thanks

[v-xiaosun-msft]

Hi @Thanh_MA ,

According to your description, I made a sample and here is my solution.

Sample data:

Method 1: You can put them in the matrix as below.

Method 2: You can create a calculated column.

times =
CALCULATE (
    COUNT ( 'Table'[DATE] ),
    FILTER ( 'Table', 'Table'[USER] = EARLIER ( 'Table'[USER] ) )
)

Final output:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.