Forum Discussion
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!
- Anonymous4 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
- AnonymousNot 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
- Thomas_MedOneHelper III
Thanks, Now I just have to figure out how to do it. Thanks.