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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
pe2950
Helper I
Helper I

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 1
v-chuncz-msft
Community Support
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.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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