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,

 

First, I would recommend a custom slicer.

Add a calculated column first in the table "tags".

 

PName =
IF (
    [ParentTagID] = 130,
    "Student",
    IF ( [ParentTagID] = 140, "Worker", IF ( [ParentTagID] = 150, "Boss", "Null" ) )
)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Second, due to the measure can be put in a slicer, we have to filter these data to a new table.

 

130 =
FILTER ( 'Tags', 'Tags'[ParentTagID] = 130 )
140 =
FILTER ( 'Tags', 'Tags'[ParentTagID] = 140 )
150 =
FILTER ( 'Tags', 'Tags'[ParentTagID] = 150 )

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

taher's avatar
taher
Helper II
9 years ago

hello v-jiascu-msft,

 

we still have the same Problem.

when I for Example filter according to the worker 'Mark', it filters all the Bosses and the Students! But 'Mark' must filter just the ones who ist not in a pair with him in the original table ( Mark has John as a Boss and Andre as a student) these but disappeared too.

It is really difficult, I'v just tried and tried but it would not work.

 

Best,

Taher