Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
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
Try this:
Turnover = DIVIDE(Turnover[Number_of_leavers],Turnover[Average_No_Employees],0)
This assumes that everything is a column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |