Forum Discussion
Anonymous
5 years agoNot applicable
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
- lbendlinSuper User
Most likely you need to use a disconnected table to feed your slicer.
Please provide sample data in usable format and show the expected outcome.
- AnonymousNot applicable
Hi lbendlin
Sample data is as per link:
https://1drv.ms/u/s!Atu2ybW156OGgQO9RJqZfflmvpnS?e=l9OYNe
Current Result:
Expected Result:
Thanks!😉
- AnonymousNot applicable
HI lbendlin , any clues on what could have went wrong in my dashboard? Grealy appreciated if you can help.