Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Code | Description |
914940002 | Some text1 |
914940004 | Some text2 |
Code | Description |
914940002 | Some text1 |
914940002, 914940004 | Some text1, Some text2 |
Solved! Go to Solution.
@OsamaKamal - Can you modify Table B? Or does it have to remain in that format?
If you can modify Table B, I would use power query to split the code column into rows. If you go into power query, and right click on the column table for code and click "Split Column" -> "By Delimiter" then select Comma. Then you can select advanced options, and split into new rows.
This will split your table and give each code line a unique row.
Then you can create a relationship between table A and table B on Code column, and your visualizations will filter as needed.
Table 1 and Table 2 are A and B respectively ? As per the tables I shared
Yep sorry. Table1 is Table A and T2 Tb
This doesn't work
@OsamaKamal - Can you modify Table B? Or does it have to remain in that format?
If you can modify Table B, I would use power query to split the code column into rows. If you go into power query, and right click on the column table for code and click "Split Column" -> "By Delimiter" then select Comma. Then you can select advanced options, and split into new rows.
This will split your table and give each code line a unique row.
Then you can create a relationship between table A and table B on Code column, and your visualizations will filter as needed.
This works. Thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
29 | |
27 | |
24 | |
22 |