Forum Discussion
Solved
Summerized Values by Group
Hello,
i would like summerize Value "LeadTime" when "Element_ID" is the same.
Can anybody help me to fix my issue ?
Hi, sod3ho
What exactly result do you need?
If you need only table Element_ID - Sum of LeadTime this code fr new table should be enough
Table = SUMMARIZE(Table1;Table1[Element_ID];"SumOfLeadTime";sum(Table1[LeadTime]))
I dont see any other planning result
In visuals do not forget to not summarize Element_ID field
Anyway, you can summarize in visuals without any additional tables
2 Replies
Hi, sod3ho
What exactly result do you need?
If you need only table Element_ID - Sum of LeadTime this code fr new table should be enough
Table = SUMMARIZE(Table1;Table1[Element_ID];"SumOfLeadTime";sum(Table1[LeadTime]))
I dont see any other planning result
In visuals do not forget to not summarize Element_ID field
Anyway, you can summarize in visuals without any additional tables
