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.

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

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'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.