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

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

Hi,

 

The sum function is to create a context to the measure. In this case, if you have only one value for eache column in your matrix/table, the result of the sum is the value it self. You can also use another function, lile min or max, it will be the same.

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

    Hi mauriciosotero ,

    My both column has close to 15 lakhs rows of record and i want to merge those columns using DAX as measure before applying any calculation over that measure, if i use min or max function it will take the min or max value over the column and it won't give my expected result.

    Hope you are getting my point.

     

    Thanks,

    -Arul

    • 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