Extract rows having MAX update_date

[Soumya_Vinod]

Hi,

I have an input table which gets updated and the datetime is stored in a separate column in the same table. From the above input, I need to develop a report which should show the data which had the latest datetime. 

Please find the screenshot and the link for the input excel.

URL:https://drive.google.com/open?id=1ANm7KhCSv2l-7G902SwhZc7dYogerdrO

[HotChilli · Accepted solution]

Easiest might be to add a slicer to the report with UPDATED_DATE then just select the date you want.  That'll filter a table on the report .

OR

Create a table with :

Table = FILTER(INPUT, INPUT[UPDATED_DATE] = MAX(INPUT[UPDATED_DATE]))