Forum Discussion

Thomas_MedOne's avatar
Thomas_MedOne
Helper III
4 years ago
Solved

Parsing Data in field

I'm pretty much a newbie when it comes to Power BI. I hae done some dashboards but nothing major.

 

Our Developer came to me to ask if PBI has this capability which is the following.

 

He has a field he said he's going to store it as JSON. However, he gave the example that the data in the field would look like this: [3,5,13,8,24] (or something similar, it may be [2,4,1,9] in another field.

 

Each number coresponds to a text value like 3 = "Sick" and 5 = "Healthy" whatever. 

 

So, he anticipates that the people involved will want to report on this information. How do I parse this out in PBI without like making duplicate records (like one per record) and that could throw off counts or creating a new field for each value which could be hard to report on.

 

Any assistance would be great. thanks!

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hey there. Tell your developer that Power Query can take that record and turn it into a list, table, table rows, table columns, or just values, and can be joined or related to lookup tables with one to many relationships, all before he realizes that the query finished 5 minutes ago.

     

    --Nate

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hey there. Tell your developer that Power Query can take that record and turn it into a list, table, table rows, table columns, or just values, and can be joined or related to lookup tables with one to many relationships, all before he realizes that the query finished 5 minutes ago.

     

    --Nate