Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello,
I need help creating a new column in Power Query.
I have column named "Deviation. " with numeric values.
Id like to add a column next to it where:
Deviation >= 60 then 'Early'
Deviation <= -300 then 'Late'
Deviation >= -299 And Deviation <= 59 then 'On Time'
Thanks!
Solved! Go to Solution.
Solved using a conditional column.
Jus the the first two*
the 3rd case is not needed.
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 15 | |
| 7 | |
| 6 | |
| 5 | |
| 5 |