Forum Discussion
Get min date for a group in M Query Power Query Editor
Hi All, I have a requirement to display the min date when status=Assigning in M query. Sample data: Requirement: My final table will need to have only one line per order. Now we are having m...
POSPOS , Add a new column in power query use the correct table name from the last step of your query
let
_val = [order number]
_min = List.Min(Table.SelectRows(#"Last Step table name", each [order number] = _val)[Effective Date])
return
_min
