Forum Discussion
Solved
Difference column in a matrix
| Client | Hours | Revenue |
| X | 123 | 20000 |
| Y | 100 | 10000 |
| 23 | 10000 | |
I created the above table in PowerBI. How do i create the 3rd column that subtracts client x from y?
11 Replies
I created the first 2 columns and would like to create the 3rd column that subracts the first 2 columns
Hi,
Assuming Hours and Revenue are measures, try this measure
=[Revenue]-CALCULATE([Revenue],Data[Client]="Client X")
Hope this helps.
That didnt work. Also hours and revenues are not measures.
Hi,
Share the link from where i can download your PBI file. Also show the expected result.
