Forum Discussion

Jagzz's avatar
Jagzz
Regular Visitor
8 years ago
Solved

PowerBI Comparison between dynamic daterange.

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!

Need Help

2 Replies

    • Jagzz's avatar
      Jagzz
      Regular Visitor
      8 years ago

      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