Forum Discussion
Solved
How to summarize a grouped date with the highest value
This is a very new experience to me and after a few attempts I am out of ideas on how to achieve this. Essentially, I need to show the highest condition for the day, however our data is being cap...
Hi, considering that you would need a column, I created this sample dataset and created a conditional column:
Below is the column calculation:
MaxCond =CALCULATE(MAX(DateCond[Condition]),ALLEXCEPT(DateCond,DateCond[orderdate]))As you can see 05/03/2024 has max condition 1, 06/03 has 0 and 07/03 has 2If this resolves your problem, then please accept this as solution to help others. Thanks!
Hi, considering that you would need a column, I created this sample dataset and created a conditional column:
Below is the column calculation:
MaxCond =
CALCULATE(
MAX(DateCond[Condition]),
ALLEXCEPT(
DateCond,
DateCond[orderdate]
)
)
As you can see 05/03/2024 has max condition 1, 06/03 has 0 and 07/03 has 2
If this resolves your problem, then please accept this as solution to help others. Thanks!
It worked, I had to edit the formula to also filter by location. I got a follow up question, how can I aggregate that into one single value for count? Off your example, there would be a count for each condition. Though it counts only one instance. So there would be
0 = 1 day
1 = 1 day
2 = 1 day