No Picture
DAX functions

Calculate Last Year Value in DAX

How to calculate the last year value in DAX? Simply use use the available DAX CALCULATE function combined with the DAX PREVIOUSYEAR function. In financial Dashboard and Reports, use the previous year value for comparison and variance calculation with the current year. How to calculate the last year value in DAX using the PREVIOUSYEAR formula? We can use directly the value from an