Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
That worked Mayil - thank you for your help
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.
That worked Mayil - thank you for your help