Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Query Editor vs Dax column

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.      T...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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