Forum Discussion
Max value with multiple criteria
Anonymous , Assuming you need the last column
Create a new column
max Grid =
var _max = maxx(filter(Table,[Week] = earlier([Week]) && [Grid] = earlier([Grid])),[value])
return
maxx(filter(Table,[Week] = earlier([Week]) && [Grid] = earlier([Grid]) && [value] =_max ),[ IP Name])
Super UserAnonymous , Assuming you need the last column
Create a new column
max Grid =
var _max = maxx(filter(Table,[Week] = earlier([Week]) && [Grid] = earlier([Grid])),[value])
return
maxx(filter(Table,[Week] = earlier([Week]) && [Grid] = earlier([Grid]) && [value] =_max ),[ IP Name])
Hi @amitchandak
Will you help again? What if I put another filter in the EXP column, where if the value "BB" is found, that value will be excluded. So the results obtained in the column "new max grid" are as follows :
| Week | Grid | IP Name | Value | Exp | Max Grid | New Max Grid |
| 1 | H | A | 4 | AA | A | A |
| 1 | I | A | 3 | AA | A | A |
| 1 | J | C | 1 | AA | A | B |
| 1 | J | A | 4 | BB | A | B |
| 1 | J | B | 3 | AA | A | B |
| 1 | K | C | 5 | AA | C | C |
| 1 | K | A | 4 | AA | C | C |
| 2 | L | D | 1 | AA | A | C |
| 2 | L | C | 2 | AA | A | C |
| 2 | L | A | 4 | BB | A | C |
| 2 | M | E | 5 | AA | E | E |
Thanks