Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have this table:
I am using the four values
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)?
Solved! Go to Solution.
Hi @Daniel3
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!!
Hi @Daniel3
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!!
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |