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 Jimmy801
Yes, I did. It would also work, if the dataset and the amount of rows were be smaller. As the dataset contains over 80 rows, the manual work with that solution would be too much. Additionally, each time new data is rolling in, I should make modifications with advanced editor according to the new data.
Thanks anyways for the solution. If nothing more simple appears, this is probably the solution I must use.
Do you have any more simple solution to suggest?
Br, Jere
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