Forum Discussion

sarikei's avatar
sarikei
Helper I
3 years ago

Previous Year

I have a slicer (Slicer A) display text of the date. i.e. Current Month, Current Year, Current Quarter. Then I have the other slicer (Slicer B) display the actual date of it. example, if Slicer A is...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

sarikei , the measures seems fine

Previous Year Sales Revenue = CALCULATE([# SalesRev], DATEADD(DateTable[Date],-1,YEAR))

 

DateTable should have all the required date

Join should be single directional

DateTable should be marked as date table

 

Slicer, visual should use DateTable for periods 

 

Why Time Intelligence Fails - Powerbi 6 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

sarikei's avatar
sarikei
Helper I
3 years ago

yes, everything looks fine but the measure didn't work.

the measure work only if I manually update the date in the Slicer B. Example, if I change the date manually as 01-12-2022 to 31-12-2022, then the previous year revenu will be calculated using 01-12-2021 to 31-12-2021, which is correct.

What I miss? Why the measure not calculating unless I update the date manually on Slicer B?