PowerBI Comparison between dynamic daterange.

[Jagzz]

I want to compute the Sales for the between a date range.  For example If I select March 1st 2017 to March 15th 2017, it has to calculate  immediate 15 days before data and show the % change. or If a user select 10 days of data it has to compare the immediate 10 days previous data and show the % change.

Please help, as this is very urgent!

[Anonymous · Accepted solution]

Hi @Jagzz,

I think following blog will suitable for your requirement.

Previous Dynamic Period DAX Calculation

Regards,

Xiaoxin Sheng

[Jagzz]

Hi Guys, thanks for the support.

But I am still confused about the flow that is provided in the blog. Would it be possible to provide the steps according to my query.

I have "SalesTable" and If I select March 1st 2017 to March 15th 2017, it has to calculate immediate 15 days before data and show the % change. or If a user select 10 days of data it has to compare the immediate 10 days previous data and show the % change.

Please help!

Thanks & regards,

Jaagz