I would like some assistance regarding an aggregation issue I have noticed across multiple Power BI Dashboards I have created
I usually confirm my results in Power BI with Excel, this was how I noticed an aggregation issue or bug.
I have noticed that the sales values for a specific month matches correctly with my Excel Check file, however, the problem arises when these sales values are aggregated across months. The values aggregated over months does not match the Excel check file. The values are relatively close but not exactly the same.
Any form of help would be much appreciated.