Measure help to count clients

[KoalaPBI]

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!

[amitchandak]

@KoalaPBI , Create a measure like

Measure =

var _max = Today() ,

var _min = date(year(_max), Month(_max) -3, day(_max) )

return

calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

or

Measure =

var _max = Today() ,

var _min =eomonth(_max,-4)+1

return

calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

[KoalaPBI]

@amitchandak thanks, but I can't get the expected result: 

[amitchandak · Accepted solution]

@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()))