Dynamic Percentage change based on date selection

[Anonymous]

Hi Everyone,

I have a requirement to show percentage change based on the date selection. 

For example, if i choose data from 24th Dec 2019 to 30th Dec 2019. Formula would be like below.

Formula = (Sales(24th -30th)-Sales(17th-23rd))/Sales(17th-23rd)

Thanks,

Anil

[Jayendran]

Hi @Anonymous ,

Could you please refer the below link

https://medium.com/seismic-data-science/dynamic-visuals-using-date-range-slicers-in-power-bi-pt-2-458423c8b213

Particularly at Create DAX equations to dynamically change metrics and text based on dates ranges sliced Section