Forum Discussion
Solved
Summing units
table 1 city, nickel quantity, date Bangalore 433.00 09/06/24 Bangalore 325.00 16/06/24 Bangalore 220.00 23/06/24 Bangalore 320.00 30/06/24 Hosur 406.00 09/06/24 Hosur 193.00 ...
you can try this
Column =
VAR _list=CALCULATETABLE(DISTINCT('Table'[Date]),ALLEXCEPT('Table','Table'[Plant_Name]))
return sumx(FILTER('Table (2)','Table'[Plant_Name]='Table (2)'[City] && 'Table (2)'[Date] in _list), 'Table (2)'[Total Units Used])
pls see the attachment below
Thank you so much ryan_mayu
With some tweaking its working perfect now.
Cheers
Column =
VAR _list=CALCULATETABLE(DISTINCT('Weekly Chem Consump'[Date]),ALLEXCEPT('Weekly Chem Consump','Weekly Chem Consump'[date].[Month], 'Weekly Chem Consump'[Plant_Name]))
return sumx(FILTER('Merged_Data','Weekly Chem Consump'[Plant_Name]='Merged_Data'[City] && 'Merged_Data'[Date] in _list), 'Merged_Data'[Total Units Used])
you are welcome