Forum Discussion

greenlover's avatar
greenlover
Frequent Visitor
4 years ago

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. 

 

 

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?

Expectation:

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

 

Hope you could help if this is possible 🙂 

 

Thank you!

 

 

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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])))