Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have unstructured data like so in one column - and I would like to split it out:
TABLE 1 |
RawData |
519 |
ABC |
XYZ |
520 |
AAA |
BBB |
CCC |
DDD |
So, I need to write some DAX to convert it into a 1 to many relationship. Generate a TABLE 2 (many) table, while maintaining the relatinship:
TABLE 1 | .......... | TABLE 2 | ... | |
RawData | ChildData | RawData | ||
519 | ||||
ABC | 519 | |||
XYZ | 519 | |||
520 | ||||
AAA | 520 | |||
BBB | 520 | |||
CCC | 520 | |||
DDD | 520 |
Is this possible?
@TonyWebCloud75 , Check if file after signature can help. Check two tables in power query
Amazing sir! Well done. What if the column as numbers and letters, how would we extract it?
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
72 | |
60 | |
59 |