Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
I'm a bit stuck and could some help with creating a conditional column or DAX nested IF statement.
Columns
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
Solved! Go to 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
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.
Thank you @mhossain ! I think a column would be best, but I'm not sure how to go about structing the formula.
@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.
Thank you @mhossain , that made sense and works perfectly! I added a few more clauses and it is exactly what I needed.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |