Forum Discussion
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.
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.
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 nullProducing 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.
2 Replies
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 nullProducing 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.