Forum Discussion

Rigolleto's avatar
Rigolleto
Resolver I
6 years ago
Solved

Parsing a column

Hi There, 

 

Just to ask about the way to take one column and create a new one with the values of the first column separated by comas?

 

Any one can advise me about the DAX statement to achive this request

 

Thanks

 

 

 

 

 

Tips and Tricks
  • Rigolleto's avatar
    Rigolleto
    6 years ago

    Hi There, 

     

    Just to ask about the way to take one column and create a new one with the values of the first column separated by DASHES?

     

    Any one can advise me about the DAX statement to achive this request

     

    I did ask about and I got an answere but, I have a new issue and it is related with the Matriz the CONCATENATEX read the whole data grid but I need to break and concatenate as the screenshot showns

     

    Thanks

3 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    6 years ago

    Hi Rigolleto 

    CONCATENATEX('Table', 'Table'[Column1], ", ")

     

  • Rigolleto's avatar
    Rigolleto
    Resolver I
    6 years ago

    Hi There, 

     

    Just to ask about the way to take one column and create a new one with the values of the first column separated by DASHES?

     

    Any one can advise me about the DAX statement to achive this request

     

    I did ask about and I got an answere but, I have a new issue and it is related with the Matriz the CONCATENATEX read the whole data grid but I need to break and concatenate as the screenshot showns

     

    Thanks

    • ImkeF's avatar
      ImkeF
      Community Champion
      6 years ago

      Hi Rigolleto 

      Yes, your column would look like so:

      CALCULATE(CONCATENATEX('Table2', 'Table2'[Column2], ", "), FILTER(ALL('Table2'), 'Table2'[Column1] = EARLIER('Table2'[Column1])))