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 Community,
Could some one please help me with the below requirement. I know how to do this in SQL using stuff function. However, with huge data i do not want to use STUFF function . I want to do this in power bi .
Support i have a requirement like below :
As the Server and serial no (first 2 columns) are same for 2 different app names and App Id's , i want the output to be like shown below.
I usually do this in SQL using stuff function .However, i would like to do this in power bi going forward. Kindly assist.
Thanks,
G Venkatesh
Solved! Go to Solution.
Hi @Anonymous ,
you can do it like this:
App ids = CONCATENATEX(VALUES('Table'[App id]), 'Table'[App id], ". ")
app names = CONCATENATEX(VALUES('Table'[app name]), 'Table'[app name],", ")
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Thanks for Providing the solution. I also want to provide a different method which i tried and worked. I used Summarize and created a new table .
You can do this by creating measures using CONCATENATEX. For example,
app name = CONCATENATEX(VALUES(Table[app name]), Table [app name], ", ")
Proud to be a Super User!
Paul on Linkedin.
Hi @Anonymous ,
you can do it like this:
App ids = CONCATENATEX(VALUES('Table'[App id]), 'Table'[App id], ". ")
app names = CONCATENATEX(VALUES('Table'[app name]), 'Table'[app name],", ")
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
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 |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |