Forum Discussion
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 s...
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)
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)