Nested IF AND Statement/Conditional Column

[Anonymous]

Hello all, 

I'm a bit stuck and could some help with creating a conditional column or DAX nested IF statement.

Columns 

• Progress (Not Started, Started, Completed)
• Start Date
• Complete Date
• Due Date

I need to create a conditional column or if statement to reflect accurate progress status. The current progress status column is populated by users and can be left blank. Therefore, even if a date is populated in the Start Date column, the status in the Progress column might reflect Not Started. 

I need a column that does the following:

 
> If Start Date field is not null and the Completed Date is not populated, the status of the Progress column should be populated as In Prorgress

> If Start Date field is not null and the Completed Date is not null, the status of the Progress column should be populated as Completed

There doesn't seem to be a way to add an AND statement to a conditional column. Is this something that could be written in a DAX statement? 

Thank you

[mhossain]

@Anonymous 

If you want to do that in the Powequery, you can create custom column.

If you want to do that in DAX environment, you can do that also.

[Anonymous]

Thank you @mhossain ! I think a column would be best, but I'm not sure how to go about structing the formula. 

[mhossain · Accepted solution]

@Anonymous 

Go to Powerquery -->Add Column -->Custom Column, and write below in your windown, name this column as "Progress"

if [Start Date] <> null and [Complete Date] = null then "In Progress" else if [Start Date] <> null and [Complete Date] <> null then "Completed" else ""

Let me know if this makes sense.

[Anonymous]

Thank you @mhossain , that made sense and works perfectly! I added a few more clauses and it is exactly what I needed.