Concatenate values from a table in another

[vyny17]

Hi guys!

I've been facing quite an advanced problem (to me XD) about finding the right DAX code to the following problem:

I have this table:

It indicates wich days the employees skipped the job.

If the day was missed it returns 1, if not, 0.

The thing is:

In another table (this table being a crossjoin between a workers table and a simple calendar table)

I need a concatenation of the zeros and ones, the result must look like something like that:

How can I do it?

I'd be glad you you guys could help me out 😄

Greetings!

[vyny17]

Great, man!

It worked! Thanks a lot!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below DAX for creating a new table, and the attached pbix file.

New Table = 
SUMMARIZECOLUMNS (
    Data[Name],
    Data[Date],
    "@Concatenation",
        CONCATENATEX (
            FILTER (
                Data,
                Data[Name] = MAX ( Data[Name] )
                    && Data[Date] = MAX ( Data[Date] )
            ),
            Data[Is_skipped],
            ", "
        )
)