Forum Discussion
SUM function incorrectly calculates weekly sales for Non Standard Date calendar
Hi Dhwanil ,
Thanks for reaching out to Microsoft Fabric Community Forum.
Based on the provided screenshot we understood that there might be duplicate records in the results set.
To get the distinct rows apply the below transformation :
let
CombinedTable = Table.Combine({Importing_TYData, Importing_Historical_Data}),
FactTable= Table.Distinct(CombinedTable)
in
FactTable
Post creating the table, create a same measure and check the data. This might be helpful.
If the issue still persists as per the lbendlin suggestion please share the sample data.If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Super UserIf I'm guessing correctly, this problem is because of filtering.
When we filter a worksheet (as long as you turn on filtering once), a hidden name is created in the workbook (or file) (you can't see it in the Name Manager of Excel). Unfortunately, it can be read by the Excel.Workbook function in Power Query.
If you use a connector to read Excel files, the connector will automatically filter out hidden names. But if it is user-written code, it may ignore this feature, and all you need to do is filter the Hidden column.
Hi ZhangKun ,
Thanks for your response. It's an interesting one!
does it happen even when there is only one sheet and no need to filter?
- ZhangKun
As long as filtering is turned on and the file is saved, a hidden name is created. Even if you turn filtering on, then turn it off, and then save it, it's the same.