Forum Discussion

Arul's avatar
Arul
Icon for Super User rankSuper User
6 years ago

Number Concatenation as a Measure

Hi Community, Could anyone please help me to concatenate two whole number column into single measure?   Thanks, -Arul
Need Help
mauriciosotero's avatar
mauriciosotero
Icon for Resolver III rankResolver III
6 years ago

Hi,

 

Is it possible to use a calculated column? If yes, you can create:

 

New Column = CONCATENATE('Table'[Col1],'Table'[Col2])

If it helps, I apreciate you give a kudo and mark as the solution. Thanks

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

    Hi mauriciosotero ,

    Thanks for your kind reply,

    I want to create the measure not the calculated column.

     

    Thanks,

    -Arul

    • mauriciosotero's avatar
      mauriciosotero
      Icon for Resolver III rankResolver III
      6 years ago

      Hi,

       

      If you need a measure, you may use:

       

      Measure = CONCATENATE(SUM('Table'[Value1]),SUM('Table'[Value2]))

       

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

        Hi mauriciosotero ,

        I just want to concatenate the two number columns in measure, I don't want to sum those columns before concatenating them. I hope you are getting my point.

         

        Thanks,

        -Arul