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!
Community SupportHi 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!
Thanks v-aatheeque , I did check all the excle files used in this report but there are no duplicated rows. But still applying Table.Distinct(CombinedTable) helped to resolve the issue. It is still a mystery why rows for only one specifc months get doubled.