Forum Discussion
Scarthart
Helper I
3 years agoProperly split values in Power BI
Very good days, I want to divide two columns but when checking the division in excel, I identify that power bi did the division wrong How can I divide these values correctly?
themistoklis
Community Champion
3 years ago
Try the following formula on a measure:
% Share =
VAR numerator =
SUM(INVENTARIO.....[Disponibilitad]])
VAR denominator =
[Rotacion Promedio Mensual]
RETURN
DIVIDE ( numerator, denominator )
Scarthart
Helper I
3 years agothemistoklis Is there a way to do it without the need for SUM or SUMX , but to divide the values without grouping them