Add data to table (snapshot)

[Sohan]

I currently have the following measure that counts the number of appointments. :

Rolling 6 month = CALCULATE(COUNTROWS(Afspraken), DATESINPERIOD(Afspraken[Datum afspraak], TODAY(), 6, MONTH)

)

I want the value that comes out of this measure to be added to a table with the date of the snapshot. For example: if on 11-07-2021 there were 100 appointments in the coming 6 months and on 12-07-2021 there were 97 appointments in the coming 6 months, I want the following table.

Date	Number of appointments
11-07-2021	100
12-07-2021	97

Does anyone know how I can achieve this?

[V-pazhen-msft]

@Sohan 

Since you are using today, to next 6 month, you will only have 1 value in the measure.

Change change Today to max(Date) in the measure:

Rolling 6 month = CALCULATE(COUNTROWS('Table'), DATESINPERIOD('Table'[Date], TODAY(), 6, MONTH))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Sohan]

This measure: 

Rolling 6 month = CALCULATE(COUNT(Afspraken[Datum afspraak]),
DATESINPERIOD(Afspraken[Datum afspraak], MAX(Afspraken[Datum afspraak]), 6, MONTH))

Seems to give the following result, which unfortunately isn't what I'm looking for. Am I doing something wrong?

[amitchandak]

@Sohan , Create a new column like this with dates

new column =
var _max = Table[Date]
return
calculate(countrows(filter(Table, Table[Date] <= _max && Table[Date] >= date(year(_max), month(_max)-6, day(_max)))))

or summarize with dates

[Sohan]

Thanks for your responde @amitchandak!

I'm getting the following result with this:

Any idea why this happens?