Forum Discussion
Split collum challenge
I see, but that is exactly what I did before for you. Check the following 2 screenshots:
The steps Source and Navigation on the right hand site are importing Excel file into Power BI. You also see how the data looks like.
The 3rd step is the split described above. Again, you see the result of this step. And it is what you expect, I hope.
Excuse me, Nolock I think I was not clear. I'm able to do the split on the current table, but I need another table to make the relationships work, as in the example above. I'm trying some DAX code to make it (new table) after the split process.
Thank you for your time and knowledge
Hi Anonymous,
unfortunately, I'm still missing your point.
What do you mean with a relationship? We have just one table with 2 columns and they are related by default.
Do you want to create a copy of a query in PowerQuery?
Yes, I need a new table, like the one from the second example above, in which I repeat the value of column "A" for each content of column "B".
Thanks for your patienceI see, but that is exactly what I did before for you. Check the following 2 screenshots:
The steps Source and Navigation on the right hand site are importing Excel file into Power BI. You also see how the data looks like.
The 3rd step is the split described above. Again, you see the result of this step. And it is what you expect, I hope.
Many thanks Nolock Clever solution.