Show only the last record in table

[zied_ahmed1]

Hello ,

I need to show only the last record in the table (the record who have the max finish date : 

In our example I need to display only Construction -> 25/07/2019

Thanks for help 

[Anil_Babu_Samineni]

If([Finish Date]=Max(TOTAL [Finish Date]), [Finish Date])

[zied_ahmed1]

Thank you for your answer but it doesn't work 

[StarinieriG]

Hi,

maybe the formula doesn't work beacause of the field, that is not in a date format.

Try with:

If([Finish Date]=Max(TOTAL Date#([Finish Date],'DD/MM/YYYY')), [Finish Date])

[zied_ahmed1]

Same problem..

My requirement is to display only the last task completed (On this project for example the last completed task is Construction 25/07/2019)

Thanks 

[Anil_Babu_Samineni]

Try below expressions in text box and see?

Max(TOTAL [Finish Date])

Or

Date(Max(TOTAL [Finish Date]))