Forum Discussion
How to add this calculated column?
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)?
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!!
1 Reply
- VahidDM
Super User
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!!