Forum Discussion

POSPOS's avatar
POSPOS
Post Partisan
2 years ago

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 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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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