Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
AlliedSol_Liz
Frequent Visitor

Combining two columns with a / between them in Power Query

How would I take the two circled columns and combine them in Power Query with a / between them? I need PageReferrer.1.2 before pagePathPlusQueryString.  This data comes directly from GA4, so Power Query is the best place to combine the two. 

 

AlliedSol_Liz_0-1738962515124.png

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@AlliedSol_Liz 
in Power Query, click on PageReferrer.1.2 press CTRL and click on pagePathPlusQueryString. under Transform tab, click Merge Column, choose as follows, provide a desired name:

Fowmy_0-1738964000432.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @AlliedSol_Liz,

Thanks for reaching out to the Microsoft fabric community forum.

 

It looks like you want to merge two column with a '/' separator between them. Please go through the solution provided by @Fowmy. If it solves your issue, please accept it as solution.

 

I would also take a moment to thank @Fowmy, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

Fowmy
Super User
Super User

@AlliedSol_Liz 
in Power Query, click on PageReferrer.1.2 press CTRL and click on pagePathPlusQueryString. under Transform tab, click Merge Column, choose as follows, provide a desired name:

Fowmy_0-1738964000432.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thank you @Fowmy! That solution worked great! 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.