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,

 

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.

    • 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

  • 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?