Forum Discussion

Helper I

3 years ago

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?

Solution Sage

3 years ago

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])

Scarthart

Helper I

3 years ago

bolfri Hi,
How strange since all I did was export the data.

Even so, I already discovered what is happening, is that when dividing the data accumulates and I do not want it to accumulate, I only take the value visible in the table

bolfri

Forum Discussion

Properly split values in Power BI

Related content

Splitting Column values

Split Value

Split values in one row into multiple

Values not populating properly in Visuals

Semantic Model not Updating Values properly