Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Print the column values multiple times using DAX

Hi there,   I am trying to print values for a specific column. for example the column name is ABC and it is occured 18 times for a key, the output needs to be as per below.   Cheers,
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

What's wrong with using REPT() ?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

lbendlin I need a delimter also to seperate the text

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    Include the delimiter in the call to REPT and throw away the last character of the result.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      lbendlin

       

      CONCATENATEX does it all for you automatically, so why bother?


      Best
      D

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        6 years ago

        Because it's fun, and an opportunity to test a function I didn't even know until very recently.