Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
@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],"/")
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |