Forum Discussion
POSPOS
Post Partisan
Post PartisanGet 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...
amitchandak
Super User
Super UserPOSPOS , 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
POSPOSPost Partisan
Post Partisan