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?
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.
@bolfri If you look here, he sent the data
Try the following formula on a measure:
% Share =
VAR numerator =
VAR denominator =
[Rotacion Promedio Mensual]
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.