Forum Discussion

vyny17's avatar
vyny17
Frequent Visitor
4 years ago
Solved

Concatenate values from a table in another

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 skip...
  • Jihwan_Kim's avatar
    4 years ago

    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],
                ", "
            )
    )