Forum Discussion

sverderame's avatar
sverderame
Helper I
7 years ago
Solved

Returning data from the wrong column

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?

Need Help
  • sverderame's avatar
    sverderame
    7 years ago

     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)

1 Reply

  • sverderame's avatar
    sverderame
    Helper I
    7 years ago

     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)