I have a WB with 20+ columns of which 3 are dates ...
I want to add a Custom Column that picks up the earliest date of those 3 columns ...
In Excel (using VBA) I can add =MIN(COL1n, COL2n, COL3n) to each cell in the Custom Column AFTER the Power Query has run but ...
Can I emulate this in the Power Query itself?
I want to add a Custom Column that picks up the earliest date of those 3 columns ...
In Excel (using VBA) I can add =MIN(COL1n, COL2n, COL3n) to each cell in the Custom Column AFTER the Power Query has run but ...
Can I emulate this in the Power Query itself?