Forum Discussion
Solved
Extract rows having MAX update_date
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
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]))
1 Reply
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]))