Pivot with multiple values

[Anonymous]

I have a table as below

Emp ID   |Managers  |Roles

A	B	Unit head
A	C	Biz HR
A	D	Biz HR
A	E	Biz HR
A	F	Ops Controller
A	G	Biz HR Manager
A	H	Budget Approver

Now when i try to pivot Roles column and values as Managers column, it gives me below output.

Emp ID|Unit head|Biz HR|Ops Controller|Biz HR Manager|Budget Approver

A

B

Error

F

G

H

In Biz Hr column it given Error as there are three Biz Hrs for A ID.

Now how can i make table with mulitple rows as below output,

Emp ID |Unit Head |Biz HR |Ops Controller |Biz HR Manager |Budget Appover

A	B	C	F	G	H
A	B	D	F	G	H
A	B	E	F	G	H

Any Help

Mohan V

[v-chuncz-msft]

@Anonymous,

You may try to use Table.FromList as the optional aggregationFunction in Table.Pivot.

[Anonymous · Accepted solution]

@v-chuncz-msft thanks for the reply.

I didnt tried the power query,

But from here, https://community.powerbi.com/t5/Desktop/DAX-Pivot-table-with-multiple-values/m-p/580610#M274664

i got the solution what i need which answered by me only.

Thanks,