Query Editor vs Dax column

[Anonymous]

Hello Community - I would like to do this in the query editor, but have the DAX reference as well for learning. 

We have Orders.   These orders begin with a prefix, like HS, AR, CO, etc.   

The HS and AR orders, below $40k value, are part of a particular sales channel.   I would like the custom column to return the value "QuickShip" if the Order prefix begins with either HS or AR, and if the Order value is equal or less than $40k.  

[Anonymous]

Thanks Phil  -  This was awesome and just what I needed!

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Here's a sample PBIX file with the following data and code.

Based on this sample data

This will do the job

= if (Text.Start([Order],2) = "HS" or Text.Start([Order],2) = "AR") 

and [Shipped Price] <= 40000 

then "QuickShip" 

else null

Producing this output

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.