Forum Discussion
homboy27
Helper III
Helper IIIDifference 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?
homboy27Helper III
Helper IIISorry let me more clear. i am trying to subtract from same columns. For example i want to add up total hours for client x and client y and i would like to subtract them. i also want to do the same for reveue.
| Client | Hours | Revenue |
| X | 1 | 12 |
| X | 2 | 12 |
| X | 3 | 334 |
| X | 4 | 34 |
| Y | 5 | 34 |
| Y | 6 | 343 |
| Y | 7 | 43 |
| Y | 8 | 34 |
