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,

 

Look for this example:

 

 

Is it works in yor case?

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

Hi mauriciosotero ,

 

Here you could see the error which i have facing while using the above formula.

 

Thanks,

-Arul

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

    Replace the ";" 'for comma ","

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

    Hi mauriciosotero ,

    That gave me the wrong result. Because that sums and then concatenate, i don't want to sum those columns before they concatenating.

    Thanks,

    -Arul

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

    Can you share a print screen of your visualization and a sample of the data?

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

    Hi mauriciosotero ,

     

     

    Assume, I have 1lakh 15 thousand rows of data, here i have shared sample only. I need the output which was in first visual but when i creating the measure by using the formula which you gave i didn't get the expected output which was in the second visual.

    Hope it helps!!

    Thanks,

    -Arul