Forum Discussion
Tricky - MAX Date Calculated Column
HI Experts I need to work out the latest ACT Date date Based on ID and NUM columns - the ACTDAte column must have dates against ALL ID and ALL NUM in order to get the MAX date. As shown in our e...
Anonymous - You are going to have to come up with solution for the error that will come from variant data-type:
Possibly just use -1 like:
also not working
CALCULATE(
MAX('table (2)'[ACTDate]),
FILTER( 'table (2)',
'table (2)'[NUM] = MAX('table (2)'[NUM]) && 'table (2)'[ID] = 'table (2)'[ID]
)
)