Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Wrong Calculation in Table for New calculated Column

I have added one calculated column in power BI table. I have exported this table from power BI to CSV file and when i check the calculated column in CSV then the calculation for one row is not matching with CSV. CSV seems correct calculation.

Have a look at the screen hsot below. Am i making some mistakes?

Power BI Table:

ashokpershad_0-1701926098790.png

 

CSV File

Screenshot 2023-12-07 075854.png

Status: Investigating

Hi @ashokpershad ,

 

Whether the expression you use in Desktop is a measure or calculated column, try the simple one:

[TotalOrder]=[Ordered Stock]*[Unit Price]

 

Best regards,
Community Support Team_ Scott Chang

Comments
v-tianyich-msft
Community Support
Status changed to: Needs Info

Hi @ashokpershad ,

 

Could you explain the logic of TotalOrder Cost and Manual Calculation?

 

Best regards,
Community Support Team_ Scott Chang

ashokpershad
Advocate II

@v-tianyich-msft 

Total Order Cost and Manual Calcualtion are based on multiplication of Ordered Stock and Unit Price. 

TotalOrder Cost is through PowerBI and Manual Calcualtion is when same table exported in CSV and I calculated using excel multiplication as can be seen in above screenshot last shared.

I am surprised to see how same multilication can give two different results. PowerBI seems not doing correct calculation.

v-tianyich-msft
Community Support
Status changed to: Investigating

Hi @ashokpershad ,

 

Whether the expression you use in Desktop is a measure or calculated column, try the simple one:

[TotalOrder]=[Ordered Stock]*[Unit Price]

 

Best regards,
Community Support Team_ Scott Chang