Forum Discussion

Microsoft Employee

7 years ago

Solved

Split 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...

Need Help

Sergiy
7 years ago
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.

https://www.dropbox.com/s/0u7p0mp2ge3ws8u/split.pbix?dl=0

Sergiy

Resolver II

7 years ago

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.

https://www.dropbox.com/s/0u7p0mp2ge3ws8u/split.pbix?dl=0

ebecerra

Microsoft Employee

7 years ago

I decided to go with Sergiy 's solution #2 using the Parsed JSON function since it gave me more flexibility to what I want to do next with the data. I did not use the GetTextFromList function since I did not actually need that list as a string.

Thank you so much!

Forum Discussion

Split a column with string and array of arrays

Related content

Extract decimal number from string/array in a column

Sort Custom Date Column in Array

Creating a String Array in Power BI

Expand array to columns

Convert string into array in power BI