Convert Formula to Power Query

[Kcroft9]

Hi All,

I'm looking for some help converting an excel formula im using (that works perfectly fine) to a Power query formula. I have decided a power query will better suit my data outcome so want to move across but obviously the language is different and I cant work out how to convert it. here is my normal excel formula:

Please Login or Register  to view this content.

Its a nice simple IF statement that includes a LEFT function.

Hope someone can help convert it into a power query formula.

Thanks in advance,

[AliGW]

Nested If/Then: https://community.powerbi.com/t5/Des...540348#M253724

LEFT function replicated: https://www.myexcelonline.com/blog/r...n-power-query/

If you attach a workbook, one of us might be prepared to help you with the exact formula.

[Kcroft9]

Hi Thanks for the reply. I have attached a data file that has the extra column added to the table showing how I would need the query to respond. But I do need the column adding in powerquery not in the direct table on excel.

thanks for any help anyone can provide.

[AliGW]

Who said anything about not doing it in PowerQuery?

Both of the links lead to information related to setting this up in PowerQuery.

[Kcroft9]

When I said I need it in PowerQuery not in excel I meant because in my data set I attached I added it to the original table in excel to show the example and didn't want there to be any confusion with what I meant

[AliGW]

OK - so what was it about the tutorials I provided that left you unable to create the formula in PQ?

[Kcroft9]

Nothing about your tutorials left me unable. in fact they were extremely helpful, I was able to create the following formula which works perfectly well.

Please Login or Register  to view this content.

I wasn't looking for someone to create it for me, I much prefer if I am able to get support in writing it myself as it teaches me something along the way
I had previously come across the LEFT function page but wasn't able to understand where to insert it, however the Nested IF page you provided is what explained the most part to work out the structure of how I needed to write it, so I'm over the moon

So, thank you for providing your support and links

[AliGW]

Brilliant - well done!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.