How to capture the values by using two date slicer

[harib]

Hi All,

We have one fact table and connected with Dim_Date table.  

We would like to implement below senario in Power BI. 

Let's say, we should have 2 date slicers like

Report Date , Previous Date 

If user selects 25-01-2021 from Report Date, the value should come as per the selected date. (Measure A)

Same way if user selects 20-01-2021 from Previous Date, the value should come as per the selected date. (Measure B)

 We would like to achive final output  like this : " Variance % = Divide(Measure A - Measure B, Measure A) " 

Can anyone help on this.

Thanks in advacne

[amitchandak · Accepted solution]

@harib , refer to my blog or video for the almost the same stuff

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

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI