Conditional Column: Can't use Conditional Column Builder

Question

I'm a beginner when it comes to query building, so all help is appreciated.

I need to create a column(3) that looks at column(1) and if it contains a value (a date), then it will look at the next column(2) and see if it contains a value (a date), if column(2) does not contain a value then I want column(3) to say "Unresolved", if there is a value in column(2), I want it to say "Resolved" ... if column(1) is null then I want column(3) to leave the column null or blank.

if column 1 is blank/null, NEW column should be blank/null

if column 1 is NOT blank and column 2 is NOT blank, NEW column = "Resolved"

if column 1 is NOT blank and column 2 IS BLANK, NEW column = "Unresolved"

v-jiascu-msft · Accepted Answer

Hi&nbsp;x2kibail,
&nbsp;
Try this one. Please also refer to the snapshot below.
Column&nbsp;=
IF&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;ISBLANK&nbsp;(&nbsp;[Column1]&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;BLANK&nbsp;(),
&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;ISBLANK&nbsp;(&nbsp;[Column1]&nbsp;)&nbsp;&amp;&amp;&nbsp;ISBLANK&nbsp;(&nbsp;[Column2]&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Unresolved",
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;ISBLANK&nbsp;(&nbsp;[Column1]&nbsp;)&nbsp;&amp;&amp;&nbsp;NOT&nbsp;ISBLANK&nbsp;(&nbsp;[Column2]&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Resolved",
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Unknown"
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;)
)

&nbsp;
Best Regards,Dale

Forum Discussion

Conditional Column: Can't use Conditional Column Builder

2 Replies

Related content

Conditional Column with Multiple Conditions

Rank with conditions

Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting