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.
Hi,
I need to create a calculated column to my dataset called "Concatenated values". The column lists all employees with the same Job except for the current person. Therefore we have three analysts and on Jessie's row, the two others are listed. How do i do this in a calculated column?
Name | Job | Concatenated values |
Jessie | Analyst | John, Dave |
John | Analyst | Jessie, Dave |
Mary | Consultant | Matt |
Matt | Consultant | Mary |
Dave | Analyst | Jessie, John |
Solved! Go to Solution.
Hi, @CarlsBerg999
Thank you for your feedback.
I tried to create a new sample based on the explanation.
Please check the link down below, and please try the below formula to create a new unique column.
New Columns CC Fix =
VAR currentjob = 'Table'[Job]
VAR currentname = 'Table'[Name]
VAR newtable =
SUMMARIZE (
FILTER ( 'Table', 'Table'[Job] = currentjob && 'Table'[Name] <> currentname ),
'Table'[Name]
)
RETURN
CONCATENATEX ( newtable, 'Table'[Name], ", " )
https://www.dropbox.com/s/kf1y8k6hentdgdj/carls.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @CarlsBerg999
Please check the below.
New Columns CC =
VAR currentjob = 'Table'[Job]
VAR currentname = 'Table'[Name]
VAR newtable =
FILTER ( 'Table', 'Table'[Job] = currentjob && 'Table'[Name] <> currentname )
RETURN
CONCATENATEX ( newtable, 'Table'[Name], ", " )
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
This seems to be doing the trick but the dataset contains the same name multiple times. Is it possible to return only the unique values? For example, now I have John 67 times on the Concatenax column
Hi, @CarlsBerg999
Thank you for your feedback.
I tried to create a new sample based on the explanation.
Please check the link down below, and please try the below formula to create a new unique column.
New Columns CC Fix =
VAR currentjob = 'Table'[Job]
VAR currentname = 'Table'[Name]
VAR newtable =
SUMMARIZE (
FILTER ( 'Table', 'Table'[Job] = currentjob && 'Table'[Name] <> currentname ),
'Table'[Name]
)
RETURN
CONCATENATEX ( newtable, 'Table'[Name], ", " )
https://www.dropbox.com/s/kf1y8k6hentdgdj/carls.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |