Forum Discussion

Long's avatar
Long
Frequent Visitor
9 years ago
Solved

Current and previous year comparison

Hi,   I am new in Power BI and DAX, need to compare each year summary with the previous year, tried many examples from the forum, nothing works for me, do not understand why the last year columns a...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    Long

    Try to tweak your measures following below sample. Check more details in the attached file.

     

    lastYear = CALCULATE(SUM(Table1[value]),PREVIOUSYEAR(Dates[Date]))

last2Year = CALCULATE([lastYear],PREVIOUSYEAR(Dates[Date]))

     

     

     

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

Long

Try to tweak your measures following below sample. Check more details in the attached file.

 

lastYear = CALCULATE(SUM(Table1[value]),PREVIOUSYEAR(Dates[Date]))

last2Year = CALCULATE([lastYear],PREVIOUSYEAR(Dates[Date]))