Forum Discussion

Wise1's avatar
Wise1
Helper I
9 years ago

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 ...
Need Help
Wise1's avatar
Wise1
Helper I
9 years ago

SLAHours = Sum(sla[SLA Hours]) 

- Problem is i cant add this up because the "SLA HOURS" is a set number which is set and differs (ie: some might be 10 hours, some 20) 

 

ie: Client A has - 10 hrs

     Client B has - 20 Hrs

 

When i sum it up- it just adds the "SLA Hours" up and gives me a number of 30 

 

 

 

 

wynhopkins's avatar
wynhopkins
Most Valuable Professional
9 years ago

But then when you put that in a table against client it should show you the total SLA hours by client

  • Wise1's avatar
    Wise1
    Helper I
    9 years ago

    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)