Forum Discussion
How to Create a Filter To Identify First 3 Text Characters - In Power Query
No that is totally fine - we are here to help :)
You forgot the "if" statement !
If you don't want to code manually, have a look at the method Vvelarde suggests above ! It uses simple dropdown lists and you are basically generating (M) code without writing it :)
So let's say the Column with the description is titled: "Project Description". How would I rewrite this in Power Query?
if Text.Start([Pays],3) = "EDT" then "External" else "Internal"
Sorry "Pays" was just an example.
Put the name of the column which contains your codes or use Vvelarde method suggested above :)
I think am missing something still. Sorry for being such a pain :)
No that is totally fine - we are here to help :)
You forgot the "if" statement !
If you don't want to code manually, have a look at the method Vvelarde suggests above ! It uses simple dropdown lists and you are basically generating (M) code without writing it :)