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 dat...
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.

     

     

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.