How to compare data between 2 custom dates Filter ?

[Anonymous]

Hello Guys,

Hope eveyone doing well.

I have one client requirement where he wants to compare the data between 2 custom dates ranges like First date range vs Second Date ranges over the period time. He wants to show this data based date x axis.

So please help !

Thank you in adavance.

Regards,

Dev

[amitchandak · Accepted solution]

@Anonymous , Refer this article for the same

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

Hello @amitchandak 

Thank you for your quick response.

I have gone through your article where I can see that you comparing data for example Jan 19  to Jan 20 data.

But my client is looking for any date range for example Feb 2019 data will compare with Jan 2020 data.

Please see the below screen shot grapgh and date selection. Is this possible ?

[amitchandak]

@Anonymous , I think two different ranges are getting compared in that article.

[Anonymous]

@amitchandak Yes, Client looking for such types date range comparision. Is this possible ?

[amitchandak]

@Anonymous , I am confused now. What you are showing in the screenshot is what given the blog I shared. You can have two  date range, two-month slicers or anything else.

[Anonymous]

Hello @amitchandak 

Thank you for your patients and reply.
Yes, But look at that date ranges and Tooltip where 2 weeks in the same month we are trying to compare using Line graph.

I want to develope the same graph in the Power BI.

Thanks,

Devanand

[v-yiruan-msft]

Hi @Anonymous,

First, you can create one calendar table. Then create a measure with the below formula:

Previous week = CALCULATE(SUM('Sales'[Sales]),DATEADD('Calendar'[Date],-7,DAY))

Best Regards

Rena