Concatenate the sentences based on categories

[NickProp28]

Dear Community, 

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.

[amitchandak]

@NickProp28 , Try concatenateX

concatenateX(Table, [Notes])

concatenateX(distinct(Table[NOTES]), [Notes])

[NickProp28]

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.

[amitchandak · Accepted solution]

@NickProp28 , A measure would be faster

you can use order by and order by expression

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax