Forum Discussion

averilboyle's avatar
averilboyle
Frequent Visitor
9 years ago
Solved

Convert SQL statement

Hi all.    I am relatively new to Power BI and am struggling a little with a problem that I would usually create a SQL case statement to label the data accordingly; essentially creating a new colum...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    I believe something along the lines of:

     

    Column = 

IF([FINISH_DATE] > [EST_DATE],
       "Fail",
       IF(ISBLANK([FINISH_DATE]) && EST_DATE < NOW(),
               "On-Going",
               "Pass"
       )
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

I believe something along the lines of:

 

Column = 

IF([FINISH_DATE] > [EST_DATE],
       "Fail",
       IF(ISBLANK([FINISH_DATE]) && EST_DATE < NOW(),
               "On-Going",
               "Pass"
       )
)
averilboyle's avatar
averilboyle
Frequent Visitor
9 years ago

Perfect!  Thank you!