Forum Discussion
Syndicate_Admin
2 years agoAdministrator
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
- edhansCommunity Champion
Use this:
List.Max(#"Case List"[End Date])