Im trying to create a calculated column to determine the status using 2 columns (initial and final review) as reference.
I have trouble how to incorporate the non-blanks into DAX.
So far I have come up with:
=SWITCH(TRUE(),[INITIAL Review]&&[FINAL REVIEW]=BLANK(),"PENDING INITIAL REVIEW",[INITIAL Review]&&[FINAL REVIEW]=,"COMPLETED",)
Many thanks in advance.
Go to Solution.
@jrpoli2000- Perhaps try this:
ISBLANK([INITIAL REVIEW]) && ISBLANK([FINAL REVIEW]),
"PENDING INITIAL AND FINAL REVIEW",
[INITIAL Review]="COMPLETED" && [FINAL REVIEW]="COMPLETED",
"PENDING INITIAL REVIEW"
Proud to be a Super User!
View solution in original post
Thanks a lot!!! also used ISTEXT because the entry sometimes for both Initial and Final Review columns will not be always COMPLETED.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.