Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Find latest time per date / Grouping?

Hi all, I'm trying to wrap my head around the following: I have auto-generated reports for a specific topic. These files are generated each 15 minutes, and I want to select the latest available f...
Need Help
  • danextian's avatar
    danextian
    6 years ago

    Hi Anonymous ,
    Are  you, by chance, connecting to a folder? If so, do the following:

     

    • Sort Date modified in descending order and wrap the resulting formula in Table.Buffer( <formula in power query>).
    • Select Date modified and go to Add Column>Date >Date Only.
    • Right-click the newly created  column and then select Remove Duplicates which should keep just the first item which is the latest date modified per date.
danextian's avatar
danextian
Super User
6 years ago

Hi Anonymous ,
Are  you, by chance, connecting to a folder? If so, do the following:

 

  • Sort Date modified in descending order and wrap the resulting formula in Table.Buffer( <formula in power query>).
  • Select Date modified and go to Add Column>Date >Date Only.
  • Right-click the newly created  column and then select Remove Duplicates which should keep just the first item which is the latest date modified per date.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, danextian - that worked and was way less complicated than I anticipated.