Forum Discussion
Find the max value by month
I have a data table showing audit date and result. I have grouped table to count the passes and fails. [audit date] - any date from 2017 to date [result] - can be 'pass' or 'fail' [count] - 1 ...
Anonymous try this measure
Max Pass Count = MAXX( VALUES( Table[Month] ), [Pass] )
parry2k
Super User
Super UserAnonymous try this measure
Max Pass Count = MAXX( VALUES( Table[Month] ), [Pass] )