Forum Discussion

shahfx's avatar
shahfx
New Member
8 years ago
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...
General Comment
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Try this:

     

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

    This assumes that everything is a column.

  • shahfx's avatar
    shahfx
    8 years ago

    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.

      

shahfx's avatar
shahfx
New Member
8 years ago

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.