Reply
Highlighted
Member
Posts: 277
Registered: ‎02-14-2017
Accepted Solution

Pivot with multiple values

I have a table as below

 

Emp ID   |Managers  |Roles

ABUnit head
ACBiz HR
ADBiz HR
AEBiz HR
AFOps Controller
AGBiz HR Manager
AHBudget 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

AB ErrorFGH

 

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

ABCFGH
ABDFGH
ABEFGH

 

Any Help

 

Mohan V


Accepted Solutions
Member
Posts: 277
Registered: ‎02-14-2017

Re: Pivot with multiple values

[ Edited ]

@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,

View solution in original post


All Replies
Community Support Team
Posts: 3,808
Registered: ‎07-09-2016

Re: Pivot with multiple values

@MohanV,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member
Posts: 277
Registered: ‎02-14-2017

Re: Pivot with multiple values

[ Edited ]

@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,