Forum Discussion
Super UserNumber Concatenation as a Measure
Super UserHi 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
Resolver IIIHi,
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