PowerQuery: Min/Max date excluding blanks across multiple columns

[illusionek]

Hello

I need to compare dates across three different columns and get the earlierst date whilst at the same time excluding any blank records. Is there any better way of doing this apart from using nested If and Max?

 

[johnny51981]

If you highlight the 3 columns and then in the "Add Column" tab, use the drop down under Date, and then select the Earliest (or latest). This will use a List.Min function, which will give you the earliest of all populated columns.

 

[illusionek]

Excellent solution. Exactly what I was after. Many thanks.