Number Concatenation as a Measure

[Arul]

Hi Community,

Could anyone please help me to concatenate two whole number column into single measure?

Thanks,

-Arul

[mauriciosotero]

Hi,

Is it possible to use a calculated column? If yes, you can create:

New Column = CONCATENATE('Table'[Col1],'Table'[Col2])

If it helps, I apreciate you give a kudo and mark as the solution. Thanks

[Arul]

Hi @mauriciosotero ,

Thanks for your kind reply,

I want to create the measure not the calculated column.

Thanks,

-Arul

[mauriciosotero]

Hi,

If you need a measure, you may use:

Measure = CONCATENATE(SUM('Table'[Value1]),SUM('Table'[Value2]))

[Arul]

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]

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]

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]

Hi,

Look for this example:

Is it works in yor case?

[Arul]

Hi @mauriciosotero ,

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

Thanks,

-Arul

[mauriciosotero]

Replace the ";" 'for comma ","

[Arul]

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]

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

[Arul]

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

[dax]

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]

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