Forum Discussion

hamzashafiq's avatar
hamzashafiq
Icon for Kudo Collector rankKudo Collector
4 years ago

Formula Help

Hi Folks,   I've similar data below with 4 cases. Each case has the required Usage difference, Sum Cost and cost/hour numbers below. I've calculated the usage and cost for three cases with the cond...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi hamzashafiq ,


So your confusion is: for case 4, the sum value is not counted according to the requirement that the hour field is not equal to 0, right? It may be useful to refer to the following formula.

Cost Sum = CALCULATE(SUM('Table'[Cost]),'Table'[Hours]<>0)
Usage Difference = MAX('Table'[Hours])-MIN('Table'[Hours])
cost/hour = [Cost Sum]/[Usage Difference]


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.