How to get last 10 days count in dax?

[a4apple]

I am using ssas tabular 1200 compatibility. I have a measure that does count rows on particular column. Now I have another measure that shows last 10 days count by using dates between in dax.

My question now is how can I show day1, day2,day3,day4....day10 counts?? The main reason is to create a mode value of these days. It is currently not working for me. Any help is appreciated. Thanks in advance.

[v-sihou-msft · Accepted solution]

@a4apple

In your scenairo, when you create last 10 days count must, it must aggregate the last 10 days count together. If you want to get each individual day count of "last 10 days", you actually filter the last 10 days date context. You can add a calculated column to tag if the dates are within "Last 10 days" range. Then just put that column into a slicer for filtering dates. See this blog: POWER BI – TIME PERIOD SLICER FOR LAST 7 DAYS,LAST 30 DAYS..

Regards,