Forum Discussion
Help with expanding json list columns
Hi all,
Thanks for your effort and replies. I found a solution to my issue from here :
https://community.powerbi.com/t5/Power-Query/Multi-Dimensional-Json-file-to-Table/td-p/113667
In the end I combined the extracted columns into one.
Hello jereaallikko
i still don't get it. The question was how to create a measure to show the result you need. What you mean by manual work? What you have to do for sure is to connect your original dataset to my example.
BR
Jimmy
Hi Jimmy801
If I have understood your solution correctly, I mean that it would take forever to modify it, since the dataset contains tens of rows.
If you have an email where I can send the original dataset and pbi query, I could do it, so we could get common understanding of the issue.
Br, Jere
Hello jereaallikko
in my example I created manually a dataset to show you a solution with DAX (measures etc.). When you need to load aaaa llloooot more data, then connect power query with your dataset, and apply afterwards my solution in DAX. ----->>>> wrong threat...
so... this now is valid for your request. The code I supplied basically transform you "list"-column to extract data from a record. you just have to apply the main step in my query to your code
Hope I was now clear enough 🙂
BR
Jimmy