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.

mhossain's avatar
mhossain
Icon for Solution Sage rankSolution Sage
6 years ago

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
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.