Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I have data tabel in Power BI
I need to merger (sum) text to have this:
I can do it to number, but I can't to text. Please help
I need this in tabel visualisation on PowerBI desktop
Solved! Go to Solution.
With DAX:
As a calculated Column (my Table is called 'FTable')
VALUE =
CONCATENATEX (
FILTER (
ALL ( FTable ),
FTable[ID] = EARLIER ( FTable[ID] )
&& FTable[Type] = EARLIER ( FTable[Type] )
),
FTable[Orig Value],
", "
)
As a measure:
VALUE1 =
VAR _id =
MAX ( FTable[ID] )
VAR _type =
MAX ( FTable[Type] )
RETURN
CONCATENATEX (
FILTER ( ALL ( FTable ), FTable[ID] = _id && FTable[Type] = _type ),
FTable[Orig Value],
", "
)
I've attached the sample PBIX file
Proud to be a Super User!
Paul on Linkedin.
With DAX:
As a calculated Column (my Table is called 'FTable')
VALUE =
CONCATENATEX (
FILTER (
ALL ( FTable ),
FTable[ID] = EARLIER ( FTable[ID] )
&& FTable[Type] = EARLIER ( FTable[Type] )
),
FTable[Orig Value],
", "
)
As a measure:
VALUE1 =
VAR _id =
MAX ( FTable[ID] )
VAR _type =
MAX ( FTable[Type] )
RETURN
CONCATENATEX (
FILTER ( ALL ( FTable ), FTable[ID] = _id && FTable[Type] = _type ),
FTable[Orig Value],
", "
)
I've attached the sample PBIX file
Proud to be a Super User!
Paul on Linkedin.
Thanks, it's working ! 🙂
Thanks for Your reply.
I try it but not working or I do some wrong.
Can You give more inforation how I can do it?
Hi,
I think this should be easy when you do it in power query.
First pivot and then concat the column should solve this.
Regards
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |