Forum Discussion

Helper III

5 years ago

Solved

Help with expanding json list columns

Hi all, I need help with modifying columns that contains List->Record. I am having a table of two columns : Id and Column1 and 82 rows. As shown below, Column1 contains List which needs to be ex...

jereaallikko
5 years ago
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.

Helper III

5 years ago

Thanks for your reply. This would have probably been the easiest way to solve the problem. But as I applied the code to my dataset, an error occurs:

Any suggestions?

Community Champion

5 years ago

Hello jereaallikko

did you check my solution?

BR

Jimmy

jereaallikko
Helper III
5 years ago
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
- Jimmy801
  Community Champion
  5 years ago
  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
  - jereaallikko
    Helper III
    5 years ago
    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

Related content