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

      • dax's avatar
        dax
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Arul,

        You could use measure like below

        Measure 5 = CONCATENATE(MIN(t4[a1]),MIN(t4[amount]))
or 
Measure 6 = MIN(t4[a1])&MIN(t4[amount])

        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.