Forum Discussion

michalintive's avatar
michalintive
Regular Visitor
9 years ago
Solved

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...
  • Greg_Deckler's avatar
    9 years ago

    Create a measure like this:

     

    MeasureX = SUM([A Revenue]) - SUM([B Project Costs])

    and then:

     

    MeasureY = [MeasureX] / SUM([A Revenue])