Parsing Data in field

[Thomas_MedOne]

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!

[Thomas_MedOne]

Thanks, Now I just have to figure out how to do it. Thanks.

[Anonymous · Accepted solution]

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