Forum Discussion
Solved
Current Year vs Previous Year
Hello everyone I have a table that contains two fields: Date Amount This table contains data of 2016, 2017 and 2018. My scope is creating a measure called Amount PY using DAX. For ...
You must use SAMEPERIODLASTYEAR() instead of PREVIOUSUEAR(), because the last one returns ALL dates from the last year, and you need the same day shifted one year back (Using SAMEPERIODLASTYEAR()).
Regards!
I think you need a separate date table for this to work, I can only see one table. Then you have to create a relationship between the two date columns.
