Forum Discussion

mudria's avatar
mudria
New Member
2 years ago
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...
Need Help
emudria3's avatar
emudria3
Regular Visitor
2 years ago

Ashish_Mathur Thank you so much for your time and effort. 

I have added two new lines in Feb data, the numbers are not adding up.

Since the purchases can happen on a daily basis, Now Feb has got 5 transactions, Feb should be should 7 ( 5 from Feb and 2 from Jan since both customers purchased in Feb)

file also attached

 

https://1drv.ms/u/c/67b14179083490c3/EaUmKZFVFLpCjfLuPRSJpOEBZ_8pKvg2HES9oif7S_80lA?e=cfSwJL

 

Since the purchases can be happening on a daily basis, The Feb isn this 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

You are welcome.  Please review your latest post thoroughly for all relevant facts.  Explain the question very clearly and show the expected result.

  • emudria3's avatar
    emudria3
    Regular Visitor
    2 years ago

    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