Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Nested IF AND Statement/Conditional Column

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's avatar
    mhossain
    5 years ago

    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.

4 Replies

  • mhossain's avatar
    mhossain
    Solution Sage

    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's avatar
      Anonymous
      Not applicable

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

      • mhossain's avatar
        mhossain
        Solution Sage

        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.