Slicer

[rbalza]

Hi Power Bi Friends,

As you can see, I have a slicer here showing the current financial year 2021 (from July 2020 to Jun 2021)  with month to date chart. Question is, how can I show the past data (financial year 2021) if I select the next financial year 2022 slicer.

For example, next month will be a new financial year (2022) and the data will be from July 2021 to Jun 2022), so if I select the 2022 slicer, I wanted to show the july 2021 data with previous financial year data for comparison. The end result would be from july 2020 to july 2021. 

[amitchandak · Accepted solution]

@rbalza , one way is add year behind measure

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))