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
wynhopkins's avatar
wynhopkins
Most Valuable Professional
9 years ago

Actually looking at this closer I think you need to use a SUM in your measures

 

 

SLAHrsTotal = SUM(sla[SLA Hours])

 

SLAHrsCalculatedPerClient = SUM(sla[MeasureTotalTimespentOrg])

 

 

SLAHrsMinusFromAllocated = [SLAHrsTotal] - [SLAHrsCalculatedPerClient]

 

 

Wise1's avatar
Wise1
Helper I
9 years ago

Thanks for your reply

Problem is the "SLA Hours" data is pulled directly from SQL as is (it comes up with error when trying to SUM) (i assume its because there is nothing to sum as its data entered) 

 

 

i have tried to do a "vlookup" of the data but its not giving me the option to type when i try enter the formula, or just something to print the data out to enable me to minus hours entered against it 

 

IE: 

 

 

  • wynhopkins's avatar
    wynhopkins
    Most Valuable Professional
    9 years ago

    Can you convert the SLA Hours to values on import in the Query editor?

    • Wise1's avatar
      Wise1
      Helper I
      9 years ago

      I cant do anything under the Query Editor as its using SQL Direct access (i think its called) 

      - Still learning PowerBi so if there is a way to do it, im willing to give it a shot or do some reading on how its done