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

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

Wise1's avatar
Wise1
Helper I
9 years ago

Hello,

 

Thanks for working with me throguh this, but it doesnt look like i can do what i need it to do through graphs

 

https://community.powerbi.com/t5/Desktop/Make-a-column-not-sum-count/td-p/24672

 

this is the issue im faced with and from reading it does not seem like there is a fix or solution yet, i have tried to change to decimal number, text, whole number

im going to try and look for a custom graph and see if i can do it with that!