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.
I have one table with a unique reference i.e. 'SPP009(b)', and I have another table with a unique reference i.e. 'SPP009(b) - text'.
The second table has text after the unique reference number within the column.
How do I make a relationship between these two columns if one has only the reference and the other has the reference and description?
Solved! Go to Solution.
Duplicate the same text column as per screenshot in query editor,
and Transform split column
and close and apply the query editor follow the steps as per screenshot,
Duplicate the same text column as per screenshot in query editor,
and Transform split column
and close and apply the query editor follow the steps as per screenshot,
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |