Forum Discussion

mageshraja's avatar
mageshraja
Frequent Visitor
7 years ago
Solved

Consolidating Column with respect to another column Reference

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 ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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.

mageshraja's avatar
mageshraja
Frequent Visitor
7 years ago

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's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

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.