Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join 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.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 5 | |
| 5 | |
| 4 |