Forum Discussion
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?
11 Replies
Try the following formula on a measure:
% Share =
VAR numerator =
SUM(INVENTARIO.....[Disponibilitad]])
VAR denominator =
[Rotacion Promedio Mensual]RETURN
DIVIDE ( numerator, denominator )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
themistoklis Is there a way to do it without the need for SUM or SUMX , but to divide the values without grouping them
Hola, podrias mejor generar una columna formulada con la misma expresion y evitarias errores en la medidas
1Daniel993 hello how can i do that
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/
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])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.
