Forum Discussion
Calculating previous year
Hey community!
Could you perhaps assist me on this one? I want to calculate previous year years value. Problem is that it only works when I have 2 years selected, I tryed both SAMEPERIODLASTYEAR() and PREVIOUSYEAR(). As you can see in the following pictures it works fine and gives me correct answer when I chose 2 years in the slicer but not if I only selected one year. I would like it to show previoys years values when I onyl selected one.
1 Reply
soderqvistn As a best practice, add date dimension in your model and use it for and time intelligence calculations. There are many posts on how to add date dimension and below is the link to a few. Once the date dimension is added, mark it as a date table on table tools.
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columnsOnce you have date dimension, previous year calculation will be based on this date dimension.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
