Forum Discussion

taher's avatar
taher
Icon for Helper II rankHelper II
9 years ago
Solved

concatenate Values repeatly

Hi All,   as you can see in the photo, I have a table of two columns. StoreId: every value is repeated three times because every value has three TagId. I'm trying to create a new column which con...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    taher

     

    Hi Taher,

     

    If you want it in DAX, you could try these two options.

    Option 1: there will be duplicate rows.

     

    New =
CALCULATE (
    CONCATENATEX ( 'Table1', 'Table1'[TagId], "-" ),
    FILTER ( 'Table1', 'Table1'[StoreId] = EARLIER ( Table1[StoreId] ) )
)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Option 2: create a new table.

     

    Table =
SUMMARIZE (
    'Table1',
    'Table1'[StoreId],
    "NewColumn", CONCATENATEX ( 'Table1', 'Table1'[TagId], "-" )
)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

taher are you saying you want to concatenate all three tagid into one row and one column?  i.e (1,2,3)

 

think you need to pivot for that in power query