Help me with the subtraction of two columns of matrix ?

[ashmitp869]

Hi ,

How can I subtract two columns in matrix .

For eg, I need to subtract PurchaseOrderValue and InvoiceAmount -

I am using matrix for the visual and they are rows.

I need to calculate Remaining cost = PurchaseOrderValue - InvoiceAmount

Note - PurchaseOrderValue  is coming from table Purchase Order nd 

[anmolmalviya05]

Hi ,

If purchaseordervalue & invoiceamount are already a measure then you can simply create below measure

Remaining Cost = PurchaseOrderValue - InvoiceAmount

Or you can calculate in below way if they are coming from column: (consider table name as example)
Remaining Cost = SUM('Purchase Order'[PurchaseOrderValue]) - SUM('Invoice'[InvoiceAmount])

As an alternative, Power BI has introduced Visual Calculation: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview

Using this you can perform calculation directly in Power BI

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for Microsoft Fabric and Power BI updates: https://www.youtube.com/@AnmolPowerBICorner

@ashmitp869

[Idrissshatila]

Hello @ashmitp869 ,

you can either create a measure that subtracts the two values or you can use visual calculations.

check it out https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview