Forum Discussion
Solved
Show duplicate/common data between 2 items in the same column + Calculate Average Cost
Hi everyone, I have the following table called "Data": Vendor Group Model Quantity Cost TAT Posting Date A S A150 150 450 67 July 7, 2018 A M A200 250 1500 75 June ...
Hi trdoan,
Could you please offer me more information about common groups and/or models?
Could you want to calculate avg data based on the group and model?
If so, you could refer to below calculated table:
Common model = SUMMARIZE('Table1','Table1'[Model],"Avg quantity",AVERAGE(Table1[Quantity]),"Avg cost",AVERAGE(Table1[Cost]),"Avg TAT",AVERAGE(Table1[TAT]))Result:
Common group = SUMMARIZE('Table1','Table1'[Group],"Avg quantity",AVERAGE(Table1[Quantity]),"Avg cost",AVERAGE(Table1[Cost]),"Avg TAT",AVERAGE(Table1[TAT]))Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi trdoan ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He