Forum Discussion
Solved
Previous Year calculation
I have a table like this and year column is availabe with 2020,2019 and 2018. Dept CY PY A 100 50 B 40 90 C 30 88 I am able to calculate the Curre...
Hi, BishwaR , did you give a shot to DATEADD(Sales[Date], -1, YEAR)? It's a common way to filter down to previous year; but pls keep in mind that since it's a time intelligence function, results based on an incontiguous date column may vary in contrast to those based on a standard time table.