Forum Discussion
Help with extracting a JSON
Success!
Instead of replacing errors with 0, I removed them instead. I can now extract the list to individual rows and perform my calculations from there.
I'm learning!
Anonymous , Check if you have a expand icon on the column two 90 degrees angle opposite to each other. If it there uses that and expands it to row and columns using that
refer these
https://www.youtube.com/watch?v=sbPS3ZKIt7g
https://powerbi.microsoft.com/en-us/blog/how-to-expand-a-list-of-records-in-a-query/
amitchandak no, the column doesn't expand or have the expansion icons. I suspect it's because the "List" is of different lengths per record (could be anywhere from 0 to 6 list entries).
Success!
Instead of replacing errors with 0, I removed them instead. I can now extract the list to individual rows and perform my calculations from there.
I'm learning!
Hi Anonymous ,
Glad that you have resolved it. You could accept your answer as solution. More people who have the same requirement will benefit from this thread.
