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
greenlover
Frequent Visitor

Values in Hierarchy Level

Hi everyone, 

 

Would like to ask for your help. I have a trend visual using a date dimension (hierarchy - year, qtr, month, day) 

 

With the view below (Monthly view from 2016 to 2022) values are correct. 

 

greenlover_0-1646811496337.png

 

However, if I drill up to yearly view, 2016 to 2022, the values are commulative. Is it possible to just get the count of December and the latest month?

greenlover_1-1646811591713.png

Expectation:

Last month of the year (december) and latest month will be displayed when the view is yearly.

greenlover_2-1646811873158.png

 

Hope you could help if this is possible 🙂 

 

Thank you!

 

 

 

 

1 REPLY 1
amitchandak
Super User
Super User

@greenlover , Can you share the meausre you ?

 

you should have a measue like this for rolling

 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

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.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.