Forum Discussion
Column Total does not match
Hi all,
We were able to identify the issue. Instead of averaging the Unit Price, we instead get the Average of PO value / Ordered Qty to arrive at the Average unit price. We also used the Round (x).
Thank you to Yangliu for your inputs and suggestions.
Hi Anonymous ,
Are you referring to the fact that PPV Total is different in power bi and excel after exporting data to excel?
You can check if there are any filters applied on the visual object, sometimes the data transformations or filters applied in Power BI may not be reflected in the exported data.
Due to rounding differences between Power BI and Excel, round() may cause differences, you can try to remove this function to see if the values are still different in power bi and excel
Check the official documentation below for the limitations related to export data:
Export data from a Power BI visualization - Power BI | Microsoft Learn
This is the related document, you can view this content:
Solved: Sum Column Total of exported data is different to ... - Microsoft Fabric Community
Solved: Wrong totals, different than export - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Noted and thanks for taking time responding to my inquiry.
Hi all,
I am validating the one in Power BI and the one extracted to Excel. See sample item below:
The one in Power BI report has no value in PPV since the Average Unit Rate in Current Year is the same as the Average Unit Rate in Last Year. However, the one extracted to Excel somehow erroneously generated a difference of (36,119.29).
How is that possible? Could it be that it has something to do with the PPV TOTAL measure?