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...
  • Shishir22's avatar
    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.