Solved: Re: Merge Column

jason81 · ‎03-26-2018

Hi All,
I am new into PowerBI and want to merge multiple rows into one row based on some values.

I found similar post but using advance editor.

Does anyone able to solve this problem via step by step query editor methods?

Thank you!

FYI,

For example:

Raw data

To be applicable by team:

VENDOR	EMAIL
10000128	marie@dyne.com; xavier@dyne.com;
10000588	Michael@Tech.com; George@tech.com; salina.chen@tech.com;
10000622	PARRYJON@uk.com; coleem@uk.com; lowppi@sg.com;

Salonic · ‎03-26-2018

Hello,

You can create a new Measure (no column) with this formula :

Mails = CONCATENATEX(Vendor;Vendor[E-Mail Address];"; ")

This will not create a new column in your table

Salonic · ‎03-26-2018

Hello,

You can create a new Measure (no column) with this formula :

Mails = CONCATENATEX(Vendor;Vendor[E-Mail Address];"; ")

This will not create a new column in your table

Merge Column