Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If([Finish Date]=Max(TOTAL [Finish Date]), [Finish Date])
Thank you for your answer but it doesn't work
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])
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
Try below expressions in text box and see?
Max(TOTAL [Finish Date])
Or
Date(Max(TOTAL [Finish Date]))