Concatenate from column Brand by columns Product & Date

[thhmez7]

Hi,

I'd like to create a column (or measure) "Combined" that concatenate the text from Brand column by Product column and Date.

It should be ordered by Brand ascending for each Product & Date.

It should look like this:

In Combined of Product C: Brand E comes before B, because A and E are on the same earlier day. So after that comes Brand B which retrieves "A+E+B".

I hope my description is clear. Thank you very much for your help.

[tamerj1]

Hi @thhmez7 
Please use

Combined =
CONCATENATEX (
    CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Product] ) ),
    'Table'[Brand],
    " + ",
    'Table'[Date], ASC
)

[thhmez7]

@tamerj1 

Thank you. I enhanced the example and the result isn't quite correct:

In Product F, Brand O should be placed before V.

In Product G, Brand G should be placed before U in "Combined". In both cases the modifiedon date is the same date.

I did this with both column and measure, same results.

How can the DAX be adapted? Thanks.

[tamerj1 · Accepted solution]

@thhmez7 
Like this

Combined =
CONCATENATEX (
    CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Product] ) ),
    'Table'[Brand],
    " + ",
    'Table'[Date], ASC,
    'Table'[Brand], ASC
)

[thhmez7]

Thank you, perfect now 🙂