Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Write New Query to return Maximum Date from table

I trying to create a list of Dates table from another table.  I would like to extract from the other table the maximum and minimum dates in the table.  I could just use the table and find the values but I don't want the extra code that was required to add the original Dates.  I need help in writing the query.    This is what I tried:

 

= Table.Column(#"Case List",maximum([End Date])) 

= Table.Column(#"Case List",([End Date]))

1 Reply

  • edhans's avatar
    edhans
    Community Champion

    Use this:

    List.Max(#"Case List"[End Date])