Forum Discussion
DAX Formula for subtracting
Hello All, I have been trying to figure the following out for the last 2 days without any luck, Basiclly what iam trying to achieve is Client - has allocated 10 hours a month 4 hrs worth ...
But then when you put that in a table against client it should show you the total SLA hours by client
Hello,
Apologies for delay in reply - was driving back from interstate location
- The formula works (and minus's the hours) but it first Adds the specified hours allocated to the client
so ive setup 2 as a test
ClientA - 20 hrs
ClientB - 10 Hrs
When i setup the dax to minus the hours it works (as you can see in picture)
Is there a possibility for a "straight conversion" so to speak to pick up the value in the cell and just convert it into a calculated form? (vlookup doesnt seem to want to work)