Forum Discussion

poweringthru's avatar
poweringthru
Helper I
3 years ago

Create new table based on JSON column using DAX

I have the following table (result column is calculated so I can't do it in Power Query):   result totalElements {"document":"110","totalElements":"3","list":[{"id":"1","items":"35"},{"id":"...
Need Help
ppm1's avatar
ppm1
Solution Sage
3 years ago

Just curious. What does the data look like before? How did you generate the JSON column? It may be easier to start from the original column(s).

 

Pat

  • poweringthru's avatar
    poweringthru
    Helper I
    3 years ago

     result comes from a table where it can have multiple different structures, in this calculated table it has been filtered down to only being this string structure.

    Maybe I can create the table in Power Query and parse it there?

    • ppm1's avatar
      ppm1
      Solution Sage
      3 years ago

      Doing it in Power Query would be much easier. You could use Json.Document to parse it.

       

      Pat