Forum Discussion

powerbi_2022's avatar
powerbi_2022
Frequent Visitor
4 years ago

How to get Previous Year Aggregate Values

I need to take Aggregated Salary values for Previous year where Year Column is not Date column -                  Employee_ID Year Month Salary 123 1 1 300 123 1 2 100 123 1 ...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

You could try it like this.

PY Salary = 
VAR _Year = SELECTEDVALUE ('Table'[Year] )
RETURN
CALCULATE ( SUM ('Table'[Salary] ),'Table'[Year] = _Year - 1 )
  • powerbi_2022's avatar
    powerbi_2022
    Frequent Visitor
    4 years ago

    Not returning any value.