Create New Calculated Column

[racheljeska]

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! 

[racheljeska]

Perfect! Thank you!

[AnalyticPulse · Accepted solution]

@racheljeska 

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:

https://analyticpulse.blogspot.com

Power BI : getting started

Dax functions

powerbi Visualisation