Forum Discussion
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?
11 Replies
- themistoklis
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
1Daniel993Helper III
Hola, podrias mejor generar una columna formulada con la misma expresion y evitarias errores en la medidas
- Scarthart
1Daniel993 hello how can i do that
- bolfri
Solution Sage
Can you put in here like... I don't know 6-7 example rows from you data? You can share it via https://wetransfer.com/
- bolfri
Hi,
data that you're comparing with are different.
Record Articulo Source Dispon Value Rotation Calculator BUJA UNIVERSAL CORTA Excel on your screen 13425 355 = 13425 / 355 = 37,8169014084507 BUJA UNIVERSAL CORTA Power BI 134250 352 = 134250 / 252 = 381,3920454545455 Different data = Different results 🙂
Both programs did thier job and gave correct results based on provided data.
Dispon = SUM(Hoja1[Disponibilidad]) Rotation = SUM(Hoja1[Rotación Promedio Mensual]) Share = DIVIDE([Dispon],[Rotation])- bolfri
Is that solved your problem or do you need a SUMX calculation (measure that performes row by row and then agregate the result)? I am sorry, but I don't understand the meaning of this columns and their business meaning.
