Divide two columns

[shahfx]

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

[Greg_Deckler · Accepted solution]

Try this:

Turnover = DIVIDE(Turnover[Number_of_leavers],Turnover[Average_No_Employees],0)

This assumes that everything is a column.

[shahfx · Accepted solution]

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.

[v-juanli-msft]

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

[Greg_Deckler · Accepted solution]

Try this:

Turnover = DIVIDE(Turnover[Number_of_leavers],Turnover[Average_No_Employees],0)

This assumes that everything is a column.