Forum Discussion
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 Evaluation be Required?] is true, then for all the [Date Evaluation Completed] blank items= open
and items with a date= completed
Thank you!
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:
2 Replies
- AnalyticPulseSolution Sage
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:
- racheljeskaFrequent Visitor
Perfect! Thank you!