Power Query Min & Max / first & last date

[Pavan.Sada.PS]

Dear Fellas

I have a table of 3 columns with Order date, Order No and invoice # information. If an invoice contain one order Min and Max date should be the same as order date. however if the invoice is having more than one order then first date of order should be min and last date or another order should be max. I was looking out for a power query solution. plz help.

 

[GraH - Guido]

Like this you mean?


Then extract the details from the last table if still required to have in the result table.