Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to display last N months data?

Hi,

 

I am trying to display last 6 months data using a new Measure of a seleted Date. However, it returns with cummulative result of the last 6 months instead of showing last 6 months' data. Appreciate if anyone can help?

 

Measure =

CALCULATE(calculate(count(Tracker[ID]), DATESINPERIOD(DIMDate[Date],max(DIMDate[Date]),-6,Month)))
 
Data:
 
Result (If I select 2020-12, table below showing 3 which is cumulative data from Jul'20 to Dec'20)
 
Date Slicer (From Date Table):
 

I've two simple tables:

 

Thanks!

 

 

 

3 Replies