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?
Ashish_Mathur
Super User
Super UserHi,
Assuming Hours and Revenue are measures, try this measure
=[Revenue]-CALCULATE([Revenue],Data[Client]="Client X")
Hope this helps.
homboy27That didnt work. Also hours and revenues are not measures.
- Ashish_Mathur
Hi,
Share the link from where i can download your PBI file. Also show the expected result.
- homboy27
Client Hours Revenue X 123 20000 Y 100 10000 Expected Result 23 10000 please see above. i created a table with the first 3 rows. Expected result column is what i would like to create. It basically subtracts the value from columns 2 and 3.