Forum Discussion
Scarthart
Helper I
Helper IProperly 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
Community Champion
Try the following formula on a measure:
% Share =
VAR numerator =
SUM(INVENTARIO.....[Disponibilitad]])
VAR denominator =
[Rotacion Promedio Mensual]
RETURN
DIVIDE ( numerator, denominator )
- Scarthart
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
- Scarthart
themistoklis Is there a way to do it without the need for SUM or SUMX , but to divide the values without grouping them
