A Power Query tip for you

You probably know that you can concatenate strings in Power Query. Not big news there. But do you know how to change the order of how things are concatenated? Patrick shows you how!


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #PowerQuery #GuyInACube

[Ready_Set_Boom]

It works the same way if you select columns then remove other columns. The columns will appear in the order selected.

[MilhouseBS]

Always something to learn. Especially when things are added after you learned it.

[rolfv]

This applies to several (if not all) functions that handle multiple columns. So for example Remove other columns will result in the remaining columns being ordered in the order you selected them in.
This example might be of less use for the end result in Power BI, but in some cases might be helpful, just to have an "important" column more to the left for example.

[alt-enter]

It does work based on the order you select them in! I found it out by accident a while ago!

[roywilson]

This also works when selecting multiple colums and re-ordering with drag and drop - select the columns in the order you want them to appear. Not as useful as your example but something to be aware of.

[mcnater]

Ha...I'm surprised you didn't know that.

[MrFirsito]

TIL i've always used column for example for this, amazing

[VikingGuard]

This feature has been around for ages, for merging and when creating a custom column from a selection.

[ykidude]

I’ve always ordered columns lastname, firstname and merge then from left to right. Does the same.

[WesStankiewicz]

I accidentally found this out for dates that were split over 3 columns! So so useful!

[ejcorcoran]

The look in Patrick's face when he realized that this worked was awesome. The feeling of teaching something to Patrick LeBlanc was even better.

[TheNms]

I would love more infos on data flows, why and when you should use them and what you can do with them

[NikUnbound]

I found this out last week as I was try different solutions for concatenation

[JCMCodaste]

I love this one. I discovered it soon by chance. Maybe advantages of starting as a (proud) "clicky draggy droppy" or however it is spelt! 😂
I say started because power query editor is not only a great graphic interface, but also an M coding trainer, coach, reference all in one place! So it's great for learning to interpret the code and tweaking it. The online version is great too! You can have the full query in the formula window. I wonder why don't they bring that to Desktop, it would be great.

[DownhillDummy]

After all the amazing videos of you guys doing all kind of cool things in power bi I can't believe you didn't know this, c'mon

[eyesleo]

If a Middle name is "Null", do I see right that we have 2 spaces between First and FamilyName?

[DivyaLakshmiJNair]

I cant make my date slicer in desired format even though i had set my power bi regional settings as default browser settings.Still it is not resolved. Can u help me?

[Mohamed.GadAllah]

I keep watching videos about "converting to a list" and "using a list" in power query, but I am confused and do not know how to use them. I like your videos, may you talk more about the list in power query?

[galrickgak]

I think you could have also changed the formula area and choose whatever columns you need first and then second. But yeah it is mind blowing

[AJ-alt]

What if I want comma after the last name? Lname, Fname M.