Forum Discussion
Solved
Sum MAX values based on two columns by day
Hi, I have data that has all sales quotes by store by day. There are four stores and seven products I'm focusing on. I want to get the maximum amount of quotes each day for each store, but can o...
You can add the Store column to your SUMMARIZE too, and then use MAXX instead of SUMX.
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeYou can add the Store column to your SUMMARIZE too, and then use MAXX instead of SUMX.
Pat
Max Quote =
SUMX (
SUMMARIZE ( Trading_Data, Trading_Data[Date], Trading_Data[store], "MaxCount", MAXX(Trading_Data,
[MaxQuotes] ) ) ,
[MaxCount]
)
Is this what you meant? It looks like it works. Thank you!
Is this what you meant? It looks like it works. Thank you!