Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

Concatenate Text with Measure not Custom Column

Hi all   I am trying to concatenate 2 text columns with a dax measure, not with query editor's custom column.   I used the dax     Concat = CONCATENATE ( SELECTEDVALUE ( Query1[[L1.3 - Countr...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    This DAX formula works

    Measure = CONCATENATEX(Data,Data[[L1.3 - Country]]]&" "&Data[[L1.8 - Bev Segment]]],UNICHAR(10))

    Hope this helps.

  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Or, if you just want a calculated column just do this:

     

    Column =

    CONCATENATE(Query1[[L1.3 - Country]]] & " ",Query1[[L1.8 - Bev Segment]]] )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
Concat = CONCATENATE (
MAX( Query1[[L1.3 - Country]]]) & " ",
MAX( Query1[[L1.8 - Bev Segment]]] )
)
  • o59393's avatar
    o59393
    Post Prodigy
    6 years ago

    hi Greg_Deckler 

     

    it didnt return all the possible combinatiosn, only 1 value:

     

     

    Thanks.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago
      Wait, what is your expected result? That was meant to create the column in your table. I don't understand what you want in your card visual. What is that?
      • o59393's avatar
        o59393
        Post Prodigy
        6 years ago

        Hi,

         

        i want to have all the combinations for these 2 columns. Instead of creating a colum, i wanted to see if it could be done with a dax.

         

        Is it possible?

         

        Thanks.