Forum Discussion
Solved
DAX - Cumulative count for only active customer
Hi Community, I need some help for a measure for cummulitive count over months - but only for the active customer in each month. say, Customer A purchased in Jan, Feb and March, it will be coun...
pls try
Ashish_Mathur
Super User
Super UserYou are welcome. Please review your latest post thoroughly for all relevant facts. Explain the question very clearly and show the expected result.
Ashish_Mathur . Very guilty and thank you for the patience.
I have updated mu orignal post.
The input data is daily dataset. Where purchases can be on daily basis.
The output is a monthly number, showing total purchases, cumulative from the historical data - but for each month only including the customers which are present/active in that month.
Regards
- Ashish_Mathur
PBI file attached.
Hope this helps.