Returning data from the wrong column

[sverderame]

Total Calendar Year Savings = CALCULATE(Project_Table[2017 Calendar]) + CALCULATE(Project_Table[2018 Calendar]) + CALCULATE(Project_Table[2019 Calendar])

I am trying to bring back values from 3 seperate columns (2017 Calendar, 2018 Calendar, 2019 Calendar) based on a 4th coulmn value (Harvest Year). basically when I filter year 2017 I want the value from "2017 Calendar" and so on for 2018 & 2019.

The formula above returns the correct value for "2019 Calendar whern I filter 2019 however it brings back values from a different column (annualized savings) for 2017 and 2018. I've tried using sum, sumx with no success.

Thoughts?

[sverderame · Accepted solution]

 I think I got it!

Total Calendar Year = CALCULATE(Project_Table[2018 Calendar], Project_Table[Harvest Year] = 2018) + CALCULATE(Project_Table[2019 Calendar], Project_Table[Harvest Year] = 2019) + CALCULATE(Project_Table[2017 Calendar], Project_Table[Harvest Year] = 2017)