Forum Discussion
AVAughan
1 year agoNew Member
Percentage Calculation
Hi there, Sorry for a very basic query but I havent been able to find a solution online. I have two columns in my table (Booked and Total) and want to find the utilisation for booking. The colum...
- 1 year ago
Make Sure you are creating a measure
Percentage = SUM('Table'[Booked])/SUM('Table'[Total])
And format it as %
arvindsingh802
1 year agoCommunity Champion
Make Sure you are creating a measure
Percentage = SUM('Table'[Booked])/SUM('Table'[Total])
And format it as %
AVAughan
1 year agoNew Member
Thank you very much! Thats exactly where I was going wrong.