I uploaded December 2022 Sales File. But Total Sales does not tally.
Refer attached pbx file Sheet M-14 Michelin Sales is AED 6.1 Mn. where as Dec. Excel file uploaded has Michelin Sale AED 7.8 Mn. If you Filter Michelin Division and Column Net Sales.
Need to understand the Excel file uploaded for Power Bi does not tally with the output in Power Bi. The file in Excel shows different no. and the file in Power Bi shows different no. The difference is at customer level for example For December 2022 , for Item Code CTM 428228 , Customer Code 10004410 has the sale value of AED 89,700, But same is not reflected in Power Bi. But it is available on Excel file uploaded for Dec’22. Not able to understand why this mismatch.
All other months tally. Not able to understand the reason for difference.
File link shared.