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 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'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"
       )
)

2 Replies

  • 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"
       )
)