Power Query- earliest and lasted dates from multiple columns.

[Mendy32]

I’m a started using PowerQuery and it has really made my working life much easier. Especially merging tables together...what I need help with is finding the earliest and latest dates from multiple columns 3-7. I have about 7200 rows..For example:

Column headers

1. name
2. Customer ID
3. IRCL date
4. IRFI date
5. iRMJ date
6. IRMC date
7. Tran date...

I know I have to add two additional columns to find the earliest date from 3-7 and lastest date 3-7. Also some dates will be missing from the rows cause not all customer went through columns 3-7.
Can you please help me...

 

[sandy666]

You are most welcome

Customer ID	IRCL	IRFI	IRMJ	IRMC	Train
aa		12/02/2010	14/02/2010	16/02/2010
aa	01/02/2020	03/02/2020		07/02/2020	09/02/2020
bb	17/01/2020		19/01/2020	20/01/2020	21/01/2020
bb	20/02/2020	22/02/2020	24/02/2020		28/02/2020
Customer ID	Earliest date	Latest date
aa	12/02/2010	09/02/2020
bb	17/01/2020	28/02/2020

// Table3
let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    Unpivot = Table.UnpivotOtherColumns(Source, {"Customer ID"}, "Attribute", "Value"),
    Group = Table.Group(Unpivot, {"Customer ID"}, {{"Earliest date", each List.Min([Value]), type datetime}, {"Latest date", each List.Max([Value]), type datetime}}),
    #"Changed Type" = Table.TransformColumnTypes(Group,{{"Earliest date", type date}, {"Latest date", type date}})
in
    #"Changed Type"