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

Sorry,

 

The idea behind this concept is for me to get an overview of clients with managed services. (at the moment is a manual process) 

 

Customers prepay lets say 10 support hours, with every case raised, labour time is deducted from the 10 support hours

 

Problem is when i try and manually minus it, it does not show up unless its a caculated field (i think that is best way to describe it) 

 

wynhopkins's avatar
wynhopkins
Most Valuable Professional
9 years ago

So for presenting the data would you have customers on the rows then 3 measures in the values

 

[SLAHours],  [TimeSpent],  [TimeRemain]

 

 

Where

 

[SLAHours] = SUM(sla[**Name of Prepaid Hours Column**])

 

[TimeSpentBase] =  Sum(**TableName**[**Name of Time Spent Column**])

 

[TimeSpent] = DIVIDE( [TimeSpentBase], [NumeratorSwitch])

 

[TimeRemain] = [SLAHours] - [TimeSpent]

 

**Indicates you need to chose the correct Table / Column name