Forum Discussion

Mahmed1's avatar
Mahmed1
Icon for Helper IV rankHelper IV
3 years ago
Solved

Filter import date to latest date on that date

Hi   i have a dataset where i have multiple import dates on a given date   what i need to do is look at the date and then go back to previous week of import date and then get the latest import da...
Need Help
Mahmed1's avatar
Mahmed1
Icon for Helper IV rankHelper IV
3 years ago

Hi 

 

what is the formula to get max date time

 

so my column has date time

 

21/07/2023 15:17:26

21/07/2023 17:17:25

 

What m code formula gives me the max date time from the column?

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    3 years ago

    Two ways

    Table.Max(Previous Step Name, "Column Name")[Column Name]

    List.Max(Previous Step Name[Column Name])