Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!
Solved! Go to Solution.
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:
Perfect! 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:
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
23 | |
15 | |
15 | |
10 | |
7 |