Forum Discussion
Divide two columns
Just perplexed with this problem and new to PowerBI, want to just divide Number of leavers / Average Number of employees but seem to get as strange number when applying the calculation below. (numbers have been generated from excel detail values) Can anyone help please
Try this:
Turnover = DIVIDE(Turnover[Number_of_leavers],Turnover[Average_No_Employees],0)
This assumes that everything is a column.
Solved the issue, this was related to trying to use the divide function without checking the columns were integer values (assumed import from excel might of taken care of that) I then used measures rather than column as was getting incorrect calculated values and having issues with showing decimals etc. Wow sometimes this was a simple issue, not giving up yet.
Thank you for all that replied.
3 Replies
Solved the issue, this was related to trying to use the divide function without checking the columns were integer values (assumed import from excel might of taken care of that) I then used measures rather than column as was getting incorrect calculated values and having issues with showing decimals etc. Wow sometimes this was a simple issue, not giving up yet.
Thank you for all that replied.
Try this:
Turnover = DIVIDE(Turnover[Number_of_leavers],Turnover[Average_No_Employees],0)
This assumes that everything is a column.
Hi shahfx
Assume [Number of leavers] and [Average Number of employees] are all columns and don't aggregation like sum, average, ect.
I test with your example data and formula, it shows the correct result as you wanted.
If you have this problem till now, please let me know what's your dataset like and whether any aggregation has been applied.
Best Regards
Maggie
