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 )
- Scarthart3 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
- Scarthart3 years agoHelper I
themistoklis Is there a way to do it without the need for SUM or SUMX , but to divide the values without grouping them