hi how i get rowlling count(days)

[ramakrishnaraavi]

how i get rowlling count(days)

[devarasu07]

Hi,

Check this article

Calculating rolling n-period totals, averages or other aggregations

how u want to find the rolling count? monthly/weekly or any other scenario ?

example, below set expression will return rolling 12 month based on user selected month (rolling 12 month)

Sum({$<Date={">=$(=MonthStart(Max(Date), -12))<$(=Date(Max(Date)))"}>} Measure)

Thanks,
Deva