Forum Discussion
Scarthart
3 years agoHelper I
Properly 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
3 years agoCommunity Champion
Try the following formula on a measure:
% Share =
VAR numerator =
SUM(INVENTARIO.....[Disponibilitad]])
VAR denominator =
[Rotacion Promedio Mensual]
RETURN
DIVIDE ( numerator, denominator )
Scarthart
3 years agoHelper I
themistoklis Hello, thank you very much, for answering it still does not give me what it should give me, that is, what is calculated for me in Excel, it should be the same calculation in Power BI