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

taher's avatar
taher
Helper II
9 years ago

Hi,

 

It seems I've wrongly imagined that I need to concatenate the column. 

I need to use the  TagId as a filter in the report, the TagId itself doesn't be allowed to filter each other, because of that I thought the best way is to split them in one row so every StoreId can get its 3 TagId without any problem and then can I filter by TagId.

 

Any idea from you would be great :)

 

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

taher,

 

Hi Taher,

 

Why can't TagId filter each other? Could you please post a sample? It's a good idea to create a new thread if it's different with this topic. That would be great for others to search solutions in the community.

 

Best Regards!

Dale