Forum Discussion
Measure to count clients
Hi there,
Following is my sample dataset:
I want to create a measure to know 'amongst people who are still in their first 3 months from signup date (that is people who signed up from 22/04/2022 onwards), count of people who made a payment since then, split across relevant months'.
For example : client_id 2 falls in this measure & made a payment in Apr, May, Jun & Jul and is counted in months from Aprl to Jul.
So, the measure result for the above dataset is like this:
Here is my sample pbi file: https://1drv.ms/u/s!Ag919_pO_UKrghcn8byYZRmTO2TS?e=INaTZr
Many thanks for your help!
KoalaPBI , Seem like you need running total
Measure = CALCULATE(distinctCount('Table'[Client_id]) ,filter(allselected(Datedim), Datedim[Date] <= max(Datedim[Date]) && Datedim[Date] >= EOMONTH(TODAY(),-4)+1 && Datedim[Date] <= TODAY()))
1 Reply
- amitchandak
Super User
KoalaPBI , Seem like you need running total
Measure = CALCULATE(distinctCount('Table'[Client_id]) ,filter(allselected(Datedim), Datedim[Date] <= max(Datedim[Date]) && Datedim[Date] >= EOMONTH(TODAY(),-4)+1 && Datedim[Date] <= TODAY()))