Forum Discussion
Solved
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. (number...
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.
Try this:
Turnover = DIVIDE(Turnover[Number_of_leavers],Turnover[Average_No_Employees],0)
This assumes that everything is a column.