Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NickProp28
Post Partisan
Post Partisan

Concatenate the sentences based on categories

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.

NickProp28_0-1632291936087.png

The outcome is like this. 

NickProp28_1-1632291962356.png

Appreciate for any help provided. 

Thank you very much.

 

1 ACCEPTED SOLUTION

3 REPLIES 3
amitchandak
Super User
Super User

@NickProp28 , Try concatenateX

concatenateX(Table, [Notes])

 

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

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],"/")
NickProp28_0-1632294007432.png

Btw, the result doesnt show in asceding form and I would like to have this new measure in new table. 
Example:

NickProp28_1-1632294135480.png

Greatly appreciate if you could give some feedback.



 

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.