Forum Discussion
Solved
Difference Value in same column between years
Hello, I'd like help and/or recommendations for adding a new indicator Card for a greenhouse gas dashboard that calculates the difference of GHG emissions between two years. All the emissions data i...
you had that as a calculated column, but you need a measure
Dif 1990 to 2020 = SUMX(FILTER(ALL(Activity), Activity[Year]=1990), [Metric Tons of Carbon Dioxide Equivalent]) - SUMX(FILTER(ALL(Activity), Activity[Year]=2020), [Metric Tons of Carbon Dioxide Equivalent])
you had that as a calculated column, but you need a measure
Dif 1990 to 2020 = SUMX(FILTER(ALL(Activity), Activity[Year]=1990), [Metric Tons of Carbon Dioxide Equivalent]) - SUMX(FILTER(ALL(Activity), Activity[Year]=2020), [Metric Tons of Carbon Dioxide Equivalent])
Thank you, though I received an error. This should be obvious but not sure what needs changing.
The syntax for '1990' is incorrect. (DAX(Dif 1990 to 2020 = SUMX(FILTER(ALL(Activity),Activity[Year]=1990), [Metric Tons of Carbon Dioxide Equivalent]) - SUMX(FILTER(ALL(Activity), Activity[Year]=2020), [Metric Tons of Carbon Dioxide Equivalent]))).
What is the (DAX... part supposed to do?