DAX - Join multiple strings and ignore null or empty values

Question

How can I join multiple strings into a single string using DAX and getting the strings from several columns of a Table

For example

"I", "", "" -> "I"

"", "got", "" -> "got"

"I", "got", "" -> "I, got"

"I", "", "rhythm" -> "I, rhythm"

How can I do this?

Answer 1

Hi,Try using the following code:

JoinText =
    CONCATENATEX ( 
        FILTER ( Table1, LEN ( Table1[Text] ) > 0 ),
        Table1[Text],
        ", "
    )

Check out the Power BI tutorial for more reference

Get an introduction to Power Bi from the below video: