cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Compare a column based on date range

Hello everyone,
I have a requirement where i need to show the comparision between SUM(Count) and their Work based on 2 date ranges.
I found this topic to be very helpful but i am unable to create a previous date measure.
https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/

I have a table like this 

requirement.PNG

Where i want compare the SUM(Count) between 2 date ranges based on this heirrarchy.Please help me to achieve the below comparision.
requirement2.PNG

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous 

Refer my blog on the same topic: https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

 



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors