Forum Discussion

Super 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

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

Super 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