Min across columns

[devries2021]

Hi

I have a table like below, I would like to calculate the minimum (earliest) date of column col1...col3 per rown and put the reult in column 'result'. In excel/sql/R/python this is trivial, but I havent found a way to do this in power query, can anyone help? Note that I want to use powerquery and not dax because I want to manipulate the table after calculating the column with minima.

Regards,

Igor

col1	col2	col3	result
1-Dec-01	2-Dec-01	3-Dec-01	1-Dec-01
3-Dec-01	2-Nov-01	8-Dec-01	2-Nov-01
1-Jun-01	4-Dec-01	3-May-01	3-May-01

[Anonymous]

try this

[HotChilli]

Go to the 'Add column' tab

Select all 3 columns (use shift )

In the 'From Date & Time' section, pick Date-> Earliest