Get min date for a group in M Query Power Query Editor

[POSPOS]

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 multiple statuses for one order number.
Show only status=Assigning by picking the first date when there are more than one dates for status=Assigning and remove all other statuses using M query and not using DAX.
Sample pbix is available here.

Thank you

[amitchandak]

@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

[POSPOS]

@amitchandak Thanks.
I get a syntax error. Can you pls suggest: