Forum Discussion

taher's avatar
taher
Helper 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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

taher,

 

Hi Taher,

 

Did you solve your problem? Could you please mark the proper answer if it's convenient for you? That will be a help to the others.

 

Best Regards!
Dale