Forum Discussion

Helper III

5 years ago

Solved

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...

Slicer Visualizations

amitchandak
5 years ago
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]))

Super User

5 years ago

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]))