Forum Discussion
Min across columns
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 |
2 Replies
Go to the 'Add column' tab
Select all 3 columns (use shift )
In the 'From Date & Time' section, pick Date-> Earliest
