Forum Discussion
Customer count over time
Hello everyone, I am in need of some help and haven't been able to figure this out. I have a list of customers from Dec 2022, Jan 2023 and Feb 2023, what I need is to get a distinct count of thes...
Hi Anonymous ,
You can also try the following dax:
Measure:
Measure = CALCULATE( DISTINCTCOUNT('Table'[Revenue Date]), FILTER(ALL('Table'), 'Table'[Customer ID]=MAX('Table'[Customer ID])&&'Table'[Revenue]>0),'Table'[Revenue Date])Calculated column:
Column = CALCULATE( DISTINCTCOUNT('Table'[Revenue Date]), FILTER(ALL('Table'), 'Table'[Customer ID]=EARLIER('Table'[Customer ID])&&'Table'[Revenue]>0),'Table'[Revenue Date])Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous can you share sample data? How the date is assigned to the customer?