Forum Discussion

KristofferAJ's avatar
KristofferAJ
Helper III
4 years ago
Solved

Create column using the earliest date (in powerQuery)

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???

 

 

Need Help
Show and Tell
Tips and Tricks
  • Shishir22's avatar
    Shishir22
    4 years ago

    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.

     

     

4 Replies

  • Shishir22's avatar
    Shishir22
    Solution Sage
    4 years ago

    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's avatar
      Shishir22
      Solution Sage
      4 years ago

      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.

       

       

  • KristofferAJ's avatar
    KristofferAJ
    Helper III
    4 years ago

    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]

  • KristofferAJ's avatar
    KristofferAJ
    Helper III
    4 years ago

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