Forum Discussion

poweringthru's avatar
poweringthru
Icon for Helper I rankHelper 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
poweringthru's avatar
poweringthru
Icon for Helper I rankHelper I
3 years ago

I know I should probably replace delimiters:

 

SUBSTITUTE([Element], """,""", "|")

 

To use the PATH functions, but I'm clueless on how to go then row by row and create a whole new table.