Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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...
Need Help
Show and Tell
Tutorial Requests
  • mhossain's avatar
    mhossain
    6 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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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
Icon for Solution Sage rankSolution Sage
6 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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