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

14 Replies

  • 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]))