Forum Discussion
ebecerra
Microsoft Employee
Microsoft EmployeeSplit a column with string and array of arrays
Hi, I've been trying to come up with a solution to the following problem with not much progress, I just can't seem to figure out what are the right steps to take. I have a table that has rows lik...
I updated my sample file adding another way of transformation. It's based on Json.Document parsing function.
There were no need for it but I think there will be no harm either.
Sergiy
Resolver II
Resolver IIHi ebecerra ,
>Is this possible in power BI or .....
I've got good news for you - it's possible :)
If I got you right you wanted something like this:
I'd like to warn you of the pitfall I ran myself recently. Power Query is case sensitive, but the Model/DAX is not.
When your sample data is loaded into the Model what you'll see looks like this:
A link to the file I made for you:
SergiyResolver II
Resolver III updated my sample file adding another way of transformation. It's based on Json.Document parsing function.
There were no need for it but I think there will be no harm either.