Consolidating Column with respect to another column Reference

[mageshraja]

Hello Everyone,

I'm trying to consolidated data in one column (Shop Order # - Level 3) wrt to another column (Shop Order # - Level 1) and get data's in one single row as shown in below output.

Can someone help me to get it done in Power Bi

Thanks,

Magesh Raja

[Zubair_Muhammad]

@mageshraja 

If you need a MEASURE, you can use CONCATENATEX to combine the values

Measure =
CONCATENATEX (
    VALUES ( TableName[Shop Order - Level 3] ),
    [Shop Order - Level 3],
    "/"
)

[mageshraja]

Hi,

Thanks for the response. But solution is not giving the intended result.

When I try it in NEW COLUMN , all the data values in the column (Shop Order # - Level 3) are getting consolidated . Not reffered by the column (Shop Order # - Level 1). 

Hope we need to Refer the column (Shop Order # - Level 1) also into the command. Any suggestions for the same.

[v-juanli-msft · Accepted solution]

Hi @mageshraja 

Create a column

Column = "/"&CONCATENATEX(FILTER(Table1,Table1[shop order level1]=EARLIER(Table1[shop order level1])),Table1[shop order level3],"/")

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.