Forum Discussion
Dynamically calculating difference between two columns in a matrix table
For illustration purpose, i am using excel but the solution i need is for Power BI. Also, this is a small sample used as an example, my real data is quite huge. I have 3 columns (image below) ...
Greg_Deckler
Community Champion
Community ChampionI'm not sure that your data is in the best format for what you are trying to accomplish, but you could do something like this and add it to Value area:
Measure = CALCULATE(SUM(Difference[Spend]),Difference[Metric]="Target") - CALCULATE(SUM(Difference[Spend]),Difference[Metric]="Actual")