Forum Discussion

AColeman's avatar
AColeman
Frequent Visitor
9 years ago

Average per Previous Year Line

  Hi I'm brand new to PowerBI and I'm teaching myself as i go along, and i must say this forum has been very helpfull to find previous topics i needed to solve some issues i had or needed to teach ...
Need Help
Tips and Tricks
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi AColeman,

 

You could have a calculated column to show the previous year average for the corresponding department.

PreviousAverage=Lookupvalue(Table[Average],Table[DerpartmentID],Table[DerpartmentID],Table[OvertimeYear],Table[OvertimeYear]-1）

Then you can use it on your visual.

 

If this is not what you want, please put your sample data into excel file and upload it, so that we can make further analysis.

 

Regards,

Charlie Liao

AColeman's avatar
AColeman
Frequent Visitor
9 years ago

Hi

 

Thanks for the response v-caliao-msft

 

But i think im doing something wrong...

 

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    Hi AColeman,

     

    Do you copy my sample DAX expression and modify the table name and file name?  Sorry for that in my DAX expression the closing parenthesis is incorrect, please delete it and re-type then you can get the expected result.

     

    Regards,

    Charlie Liao