Convert SQL statement

[averilboyle]

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

This is my statement:

CASE WHEN
       FINISH_DATE > EST_DATE THEN 'Fail'
WHEN
       FINISH_DATE IS NULL AND EST_DATE < GETDATE() THEN 'On-Going'
ELSE
       'Pass'
END AS SLA_Status

Any idea how I can get this in Power BI and the Fail / On-Going / Pass information into a new column?

Thanks in advance.

[Greg_Deckler · Accepted solution]

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]

Perfect!  Thank you!