How to Merge Columns in Power BI


How to merge columns in Power BI

Let's get it together Reader,

Specifically, let's learn how to MERGE columns in Power BI. Sometimes, our data is spread across multiple columns and we may need to bring it together.

Maybe you have address data but the street number and the street name are in their own columns... maybe you have first and last names of customers/clients/staff/whoever and need those names to come together.

Power Query Editor: Merging Columns

Not loving How To Use Power BI in your inbox anymore? Unsubscribe here.

(because you should only get these emails if you love them and find them useful!)

Recent Power Query Transformation Posts:

How to document your Power Query data transformations

Your future self (and everyone else) will thank you.

Power Query: Add Column from Examples

Make a new column based on just about anything in another column!

Evaluate This!

I've entered a fun little sticker competition for the American Evaluation Association conference.. here are my 3 submissions. I'll be bringing some to the conference too.

You want Outcomes?


More from Joe (me)!

You can learn from me in a workshop

I run friendly and informative Beginner and Advanced Power BI workshops. Get started (or level up if you already know the basics) so you can start reporting insights from your data ASAP! Hit the reply button on this email and let's chat.

You can pick my Power BI Brain

After 7+ years of using Power BI daily, I've come across (and sworn at) a LOT of error messages, things that don't make sense, and other challenges. You don't have to go through it all too... you can get me to help you through the challenges. Don't spend hours/days/weeks being frustrated... I've already gone through that FOR you. Talk to me. I can help.

Take care everyone,

Joe.

TraversData.com | LinkedIn | Instagram



Subscribe to Joe Travers