Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help to calculate the difference between two years

Hi,   Would really appreciate any help. I'm still learning Power BI and struggling to create a card which shows the difference in the average % from 2020 and 2015.   I've tried a couple methods i...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , In case you have selected a year or something from calendar table , then prefer to use all in calendar filter

     

    2014 Average = CALCULATE(AVERAGE('Strategic Projects'[Local Content (%)]),filter(all('Calendar'),'Calendar'[Date]="2014"))


    2020 Average = CALCULATE(AVERAGE('Strategic Projects'[Local Content (%)]),filter(all('Calendar'),'Calendar'[Date]="2014"))


    2020 to 2014 difference = [2020 Average]-[2014 Average]

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , In case you have selected a year or something from calendar table , then prefer to use all in calendar filter

 

2014 Average = CALCULATE(AVERAGE('Strategic Projects'[Local Content (%)]),filter(all('Calendar'),'Calendar'[Date]="2014"))


2020 Average = CALCULATE(AVERAGE('Strategic Projects'[Local Content (%)]),filter(all('Calendar'),'Calendar'[Date]="2014"))


2020 to 2014 difference = [2020 Average]-[2014 Average]