Forum Discussion

pe2950's avatar
pe2950
Helper I
9 years ago

DAX: Using Date Hierarchy while comparing the the same period of prior year?

I'm trying to display my data in such a way, using date hierarchy, where it compares it with the same period prior year. 

 

My data is structured in such that each row counts as 1, so to calculate the number of sales for any given period it is SUM([sale]).  The data basically has a sale column that contains a 1, and a date column that contains the date of the sale. 

 

I'm trying to compare with the same period for the prior period, such that when you view 2017, it is only showing 2016 up until today, when you click on the year and drills down into the quarter view, you only see all quarters up until today, and same for the month view. 

 

Is this possible? 

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    pe2950,

     

    You may select the third icon "Expand all down one level in the hierarchy" in the top left corner of the visualization.