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:
CSV File
4 Comments
Hi ashokpershad ,
Could you explain the logic of TotalOrder Cost and Manual Calculation?
Best regards,
Community Support Team_ Scott Chang- ashokpershad
Advocate II
Anonymous
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.
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- ashokpershad
Anonymous
Its Calculated Column
