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 October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!