Need Help with SWITCH or IF function

Question

Hi!&nbsp;Im trying to create a calculated column to determine the status using&nbsp;2 columns (initial and final review) as reference.&nbsp;INITIAL REVIEWFINAL REVIEWSTATUSCOMPLETED&nbsp;PENDING FINAL REVIEWCOMPLETEDCOMPLETEDCOMPLETED&nbsp;&nbsp;PENDING INITIAL AND FINAL REVIEW&nbsp;I have trouble how to incorporate the non-blanks into DAX.So far I have come up with:&nbsp;=SWITCH(TRUE(),[INITIAL Review]&amp;&amp;[FINAL REVIEW]=BLANK(),"PENDING INITIAL REVIEW",[INITIAL Review]&amp;&amp;[FINAL REVIEW]=,"COMPLETED",)&nbsp;Many thanks in advance.

greg_deckler · Accepted Answer

jrpoli2000- Perhaps try this:&nbsp;STATUS = 
SWITCH(
    TRUE(),
    ISBLANK([INITIAL REVIEW]) &amp;&amp; ISBLANK([FINAL REVIEW]),
        "PENDING INITIAL AND FINAL REVIEW",
    [INITIAL Review]="COMPLETED" &amp;&amp; [FINAL REVIEW]="COMPLETED",
        "COMPLETED",
    "PENDING INITIAL REVIEW"
)

Forum Discussion

Need Help with SWITCH or IF function

2 Replies

Related content

Switch or If Function

Switch function

problem with SWITCH function

SWITCH FUNCTION

Alternative to SWITCH ()?

INITIAL REVIEW	FINAL REVIEW	STATUS
COMPLETED		PENDING FINAL REVIEW
COMPLETED	COMPLETED	COMPLETED
		PENDING INITIAL AND FINAL REVIEW