Forum Discussion
vyny17
4 years agoFrequent Visitor
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...
- 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], ", " ) )
vyny17
4 years agoFrequent Visitor
Great, man!
It worked! Thanks a lot!