Change text if another column contains a date or is not blank

[joannerw]

This is an example of a data set I have which I need to change the Status of "Outstanding" to "Partially Complete" if there is a date in the Start Date column. I've highlighted the rows that this would apply to.

[tamerj1]

Hi @joannerw 
If you are seeking a power query solution, then

= Table.AddColumn(#"Changed Type", "Custom", each if [Finsih Date] = null and [Status] = "Outstanding" then "Partially Complete" else [Status])

[joannerw]

Thank you @tamerj1 . I had trouble getting this to work for me as I'm fairly new to Power BI and wasn't sure how to apply it bit I found amitchandak's solution worked for me. Thank you for taking the time to assist.

[tamerj1]

@joannerw 

I also prefer dax. It's easier 😅 you can download the sample file, open the query editor and the see the steps. 

[amitchandak · Accepted solution]

@joannerw , A new column in DAX

= If([Status] ="Outstanding" && not(isblank([Start Date])) , "Partially Complete", [Status])