Create column using the earliest date (in powerQuery)

[KristofferAJ]

HI,

Im moving my calculated columns into powerquery as I believe thats the 'right' way to do it..

I have some simple calcualtions like a "START" date

Which is the earliest date between 2 dates, I have handled this with a 'normal' MIN function in the desktop.

But how can I express this within a 'add column' in powerquery itself???

[KristofferAJ]

Not working but I understand your line of thinking and I can tweak it as a conditional column! thanks a lot

[KristofferAJ]

Thanks @Shishir22 , whis works... but what if there is no [Site FSI Actual] date... then I will be stuck with a blank, even if the is a [Site RTE Actual]

[Shishir22 · Accepted solution]

Please try- 

= if ([Site RTE Actual] < [Site FSI Actual] then [Site RTE Actual] else [Site FSI Actual]

Please mark it as answer if it solves your issue. Kudos are also appreciated.

[Shishir22]

If that is the case then you need to add that condition also- 

= if [Site RTE Actual] < [Site FSI Actual] then [Site RTE Actual] 
else if [Site FSI Actual] > [Site FSI Actual] then [Site FSI Actual]
else if [Site FSI Actual] = "" then [Site FSI Actual]
else [Site FSI Actual]

Please mark it as answer if it resolves your issue. Kudos are also appreciated.