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
ryan_mayu
Super User
Super Userwhat if customer B purchase in Apr and May again? so B is 1 Jan, 2 in Feb, 0 in Mar, 1 in APR and 2 in May?
Anonymous
Ideally it should be 1 in Jan, 2 in Feb, 2 in Mar, 3 in Apr, 4 in May.
Looking at any month, Ideally, we only count the customers which have a purchase in that month to get to the cumulative number.
- ryan_mayu
this is against your first post.
B didn't appear in Mar and you didn't count B in Mar as well. the 5 is from 3 A and 2 C.
not sure if i understand this clearly ,maybe you can try this