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.
Hello experts
I have a requirement to combine every 2 columns of a table and then display the concatenated columns in a saperate table.
I am able to cross join and concatenate the result of the columns, but I cannot display the concatenated columns in a single table as the final result. At one point I can show only one column.
Code;
Test1 | Test2 | Test3 | test4 |
one | one | Jobs | one |
one | one | Works1 | one |
one | two | Jobs2 | one |
one | 3 | Jobs3 | two |
one | 3 | Jobs4 | one |
one | 4 | Jobs5 | one |
In the above image there is a column with the cross join and concatenation of Test2 and Test3, My requirement is to add 2 more columns with the concatenation of Test1 and Test2 and the concatenation of Test3 and Test4
@siva_powerbi , too many cross join. Please let us know what are you try to achieve.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I have added the sample data in the question, it is the data I am working on.
My requirement is to out of 4 columns.
Make cross join of col1, col2 and col2,col3 and col3,col4
Then concatenate cross joins with "," and show the resultant values in a table side by side.
I tried to attach the file but it doesn't carry the data in datasource, May I know the exact process.
Thanks
@siva_powerbi Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Sir, Just updated the question, Please check and advice.
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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |