Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
53 | |
46 | |
19 | |
16 | |
13 |
User | Count |
---|---|
108 | |
56 | |
29 | |
21 | |
18 |