Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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" ) )
I believe something along the lines of:
Column = IF([FINISH_DATE] > [EST_DATE], "Fail", IF(ISBLANK([FINISH_DATE]) && EST_DATE < NOW(), "On-Going", "Pass" ) )
Perfect! Thank you!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |