Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Query Editor-Replace Errors in Date column with latest date

Hello,   i have a file where in one of the columns i have dates or text value "History".   What i want to do in the query editor is to replace the "History" with latest date in the column.   Wh...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi Anonymous ,

    I would write it like so:

     

    Table.ReplaceErrorValues(#"Changed Type", {{"Date", List.Max(Table.RemoveRowsWithErrors(#"Changed Type", {"Date"})[Date])}})

     

     

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

I would write it like so:

 

Table.ReplaceErrorValues(#"Changed Type", {{"Date", List.Max(Table.RemoveRowsWithErrors(#"Changed Type", {"Date"})[Date])}})

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Works, thank you for your support !