Doing a filter in query editor on date for "Is Latest" returning empty.

[Anonymous]

I am bringing in a dataset, and in the query editor on ther data set I want the datetime field to be set to "Is Latest"  I'm assuming that means only the rows with the latest datetime will be there.   So in this case 8/17 11:32:53 would be the latest.  When I choose "Is Lastest" from the filter arrow,  it comes back blank.  I'm not sure why because there is clearly data there.  

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

try converting the column to date only instead of date time, i tried it and it filtered.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[Anonymous]

I'm not really looking to get anything based on id.  I just want the most current lines based on the datetime.  So in the above screenshot, the lines that say 8/17/2023 11:32:53am is would I want to keep.  In the filter drop down arrow, there is a selection for "Is Latest" date time filter, which I would think would keep the three latest lines.  But when I select it, the table comes back empty.

[AbhinavJoshi]

Hello @Anonymous, if you are looking to get the latest date based on an ID, I'd advise to use a group by. In Power Query Editior, click on Group By your ID, once in the group by wizard, click on Advanced. In the aggregation part, add DateTime in the New column name, Max as the operation, and DateTime in the Column. Then click on Add aggregation and in the Operation, select all rows. I hope it works for you.

Thanks,

Abhinav