Forum Discussion
bcap01
Helper II
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 d...
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/
ValtteriN
Community Champion
Community ChampionHi,
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/