Forum Discussion
Generate a one to many for the same table
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?
2 Replies
- amitchandak
Super User
Amazing sir! Well done. What if the column as numbers and letters, how would we extract it?
