Forum Discussion
Solved
Create New Calculated Column
Column [Will Evaluation be Required?] has choices of True, False, or Blank Coulmn [Date Evaluation Completed] gives a date or is blank if not completed I want a new column that says: If [Will E...
Please try below dax to add new calculated column:
Evaluation_Status = IF( [Will Evaluation be Required?] = TRUE(), IF( ISBLANK([Date Evaluation Completed]), "Open", "Completed" ), BLANK() )
Learn Power BI free:
Please try below dax to add new calculated column:
Evaluation_Status = IF( [Will Evaluation be Required?] = TRUE(), IF( ISBLANK([Date Evaluation Completed]), "Open", "Completed" ), BLANK() )
Learn Power BI free: