Forum Discussion
joshua1990
Post Prodigy
Post ProdigyCALCULATE MAX and exclude specific rows
Hi all!
I have a table that has multiple entries / rows for each article.
Now I would like to get the max value out of a specific column with filtering out specific rows where in a different colu...
=MAXX(FILTER(Table,NOT(Table[Key] IN {"A","B"})),Table[Value])
wdx223_Daniel
Community Champion
Community Champion=MAXX(FILTER(Table,NOT(Table[Key] IN {"A","B"})),Table[Value])
joshua1990Post Prodigy
Post Prodigywdx223_Daniel : Thanks a lot! Would you still use this if the table has 5MM rows?