I'm looking for a Beast Mode formula to create a MAX calculation by ID in my table.
My resulting column should look like column B below.
I already tried a formula with Distinct and MAX but while the formula was valid, my attempt still failed at producing desired results.
Keep in mind that in my scenario, column A is a calculated field already, don't know if that makes a difference.
Thanks!
ID | column A | column B - max aggregate |
11 | 0 | 1 |
11 | 1 | 1 |
21 | 0 | 1 |
21 | 1 | 1 |
31 | 0 | 0 |
31 | 0 | 0 |