Forum Discussion
Jagzz
8 years agoRegular Visitor
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...
- Anonymous8 years ago
Hi Jagzz,
I think following blog will suitable for your requirement.
Previous Dynamic Period DAX Calculation
Regards,
Xiaoxin Sheng
Anonymous
8 years agoNot applicable
Hi Jagzz,
I think following blog will suitable for your requirement.
Previous Dynamic Period DAX Calculation
Regards,
Xiaoxin Sheng
- Jagzz8 years agoRegular Visitor
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