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.
Hello, Power friends,
I have the following data source in excel format.
A | B |
144987 | #199270 #199271 |
148511 | #344827 #344816 #344838 #344823 |
148511 | #344831 #344825 #344840 #344822 #344815 #344834 #344837 #343949 |
I need to separate all data starting with "#" in column "B" to generate a new table with the relationship between column A and B, such as:
A | B |
144987 | #199270 |
144987 | #199271 |
148511 | #344827 |
148511 | #344816 |
148511 | #344838 |
148511 | #344823 |
And, so on...
Note that there is no fixed number of strings beginning with "#" in column B.
Thanks for your time.
Solved! Go to Solution.
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.
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 |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |