Forum Discussion

Wise1's avatar
Wise1
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
9 years ago

 

Thanks for replying, it does not seem to work with the method above, but works when i do it with only lets say [SLA Hours]

 

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Wise1,

 

You can use the SUM function in DQ mode if you go to Options -> DirectQuery and enable "Allow unrestricted measures in DirectQuery mode".:smileyhappy:

 

 

 

Regards

  • Wise1's avatar
    Wise1
    Icon for Helper I rankHelper I
    9 years ago

    Just thought i would reply so people dont think i have forgotten about this thread

     

    Still trying to pull it together, but getting closer! thanks everyone for their input so far!