Forum Discussion
Slicer
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.
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]))
1 Reply
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]))