I am doing the data cleansing for my raw data.
And would like to ask isit possible to concanate the notes in ascending (A-Z) based on Consol ID and Type.
The outcome is like this.
Appreciate for any help provided.
Thank you very much.
Go to Solution.
@NickProp28 , A measure would be faster
you can use order by and order by expression
View solution in original post
@NickProp28 , Try concatenateX
Dear @amitchandak ,
Thanks for your attention!
I tried this code, its work. But this took long time to run. Would like to ask is my code is correct?
Conc = CONCATENATEX(SUMMARIZE(FILTER(Concat,Concat[Consol ID ]=EARLIER(Concat[Consol ID ])&& Concat[Type]=EARLIER(Concat[Type])),Concat[Notes]),Concat[Notes],"/")
Btw, the result doesnt show in asceding form and I would like to have this new measure in new table. Example:
Greatly appreciate if you could give some feedback.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.