Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have a series of files named by year 2011 to 2022 in the file the headers are as follows. Where if you open a file the same fiscal year will be the same for every row.
I have brought all of these files into Power Bi, and created a simple table that sums the total of each column. This table can be shown below.
To validate that the table was summing values correctly, I recreated this table from the source data and found that the values in the red boxes do not match with the values calculated from the table i created from the source table.
The picture below outlines the results of me carrying out this process in Excel. I also compared the number of rows in the source data and the power bi data and it is the same amount but the sums are different. I have resolved all errors in my queries.
I think I might have set something up incorrectly in Power BI for it to not calculate correctly. i am just not sure what.
Can someone please help?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |