How to add this calculated column?

[Anonymous]

I have this table:

I am using the four values

• Soll = debit
• Haben = credit
• Konto = posting account
• Kontoname = posting account name

to create this visual that aggregates the debit and credit:

How can I add a fifth column to the visual that show the difference between debit and credit (credit - debit)?

[VahidDM · Accepted solution]

Hi @Anonymous 

Try this to add a new column to the table, then use that in the visual:

Column = [Haben]-[Soll]

Or try this measure:

Difference= sum(Buchungen[Haben])-sum(Buchungen[Soll])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!