Forum Discussion
Helper IIDAX - SUM and Divide 2 fields
Hi am a newbie here,
I am looking to do a simple DAX formula to add to values then Divide one of them to get the average.
For example:
Bill Hours = 6 + Non-Bill Hours = 2 = 8 hours
Then divide the Bill Hours 6/8 Total hours = 75%
Can someone help me understand how to do something like this in DAX?
Hi,
Hi,
Assuming you have these on columns try something like this: DIVIDE(SUM(Table[Billhour]),SUM(Table[Billhour])+SUM(Table[non-Billhour]))
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
1 Reply
- ValtteriN
Community Champion
Hi,
Hi,
Assuming you have these on columns try something like this: DIVIDE(SUM(Table[Billhour]),SUM(Table[Billhour])+SUM(Table[non-Billhour]))
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/