Max Date in a Table Dimension

[kevinstanfield]

Hi,

I have a table that I only wish to display the most recent date value in the dimension.

I've tried various approaches but each time I get an Invalid dimension message

=if(Max(date([Aged Debt Date])),[Aged Debt Date],)

 =Max([Aged Debt Date])

I have also have the date as serial number and have tried Set Analysis  where serial number =  max (serial number) but I'm not getting anywhere.

I'm assuming I'm missing something glaringly obvious?

Thanks in advance

Kevin

[MayilVahanan · Accepted solution]

Hi @kevinstanfield 

Try like below

=Aggr(If([Aged Debt Date]= Max(Total [Aged Debt Date]), [Aged Debt Date]),[Aged Debt Date])

And check , suppress when value is null.

Hope it helps.

[kevinstanfield · Accepted solution]

That worked Mayil - thank you for your help