Forum Discussion
michalintive
9 years agoRegular Visitor
Power BI subtracting
Hi all, I need to create a new column with resoult of subsctracting two columns in Matrix view. I've tried to do it by guides in this community but I wasnt able to do it. I need to do calcula...
- 9 years ago
Create a measure like this:
MeasureX = SUM([A Revenue]) - SUM([B Project Costs])
and then:
MeasureY = [MeasureX] / SUM([A Revenue])
Greg_Deckler
9 years agoCommunity Champion
Create a measure like this:
MeasureX = SUM([A Revenue]) - SUM([B Project Costs])
and then:
MeasureY = [MeasureX] / SUM([A Revenue])