Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not 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:
Count of ID.PNG
 
Result (If I select 2020-12, table below showing 3 which is cumulative data from Jul'20 to Dec'20)
Measure by selected month.PNG
 
Date Slicer (From Date Table):
Date.PNG
 

I've two simple tables:

Table.PNG

 

Thanks!

 

 

 

3 REPLIES 3
lbendlin
Super User
Super 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.

Anonymous
Not applicable

HI @lbendlin , any clues on what could have went wrong in my dashboard? Grealy appreciated if you can help. 

Anonymous
Not applicable

Hi @lbendlin 

 

Sample data is as per link: 

https://1drv.ms/u/s!Atu2ybW156OGgQO9RJqZfflmvpnS?e=l9OYNe

 

Current Result:

Current Result.PNG

Expected Result:

Expected Result.PNG

 

Thanks!😉

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Kudoed Authors