Forum Discussion

PietroFarias's avatar
PietroFarias
Icon for Resolver II rankResolver II
5 years ago
Solved

Concatenate values from a DAX column

How do I transform the result of a DAX function in table format to a scalar value concatenating each record. The expected result is the example below:
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi PietroFarias 

    CONCATENATEX( DISTINCT(Table1[Name]), Table1[Name], ", ")

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi PietroFarias 

CONCATENATEX( DISTINCT(Table1[Name]), Table1[Name], ", ")

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers