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
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.

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

    Hi dax ,

     

    Could you please help me by clarifying why we were using MIN here. If we use min it will take the minimum value of the column.

     

    Thanks,

    -Arul