Microsoft released TOCSV and TOJSON but not the obvious companions, FROMCSV and FROMJSON. Well, here's at least FROMCSV DAX code for everyone! Now you can theoretically store tables in measures using TOCSV and convert them back to a table when you need to within other measures.
FromCSV1 =
VAR __NumRows = LEN([ToCSV1]) - LEN(SUBSTITUTE([ToCSV1],UNICHAR(10),"")) + 1
VAR __Text = SUBSTITUTE(SUBSTITUTE([ToCSV1], UNICHAR(13),""),UNICHAR(10),"|")
VAR __Rows =
GENERATE(
GENERATESERIES(1, __NumRows, 1),
VAR __Row = SUBSTITUTE(PATHITEM(__Text, [Value]),",","|")
VAR __Val1 = PATHITEM(__Row, 1)
VAR __Val2 = PATHITEM(__Row, 2)
RETURN
ROW (
"Column1", __Val1,
"Value1", __Val2
)
)
RETURN
__Rows
And the video!
eyJrIjoiNzUxNDE0NTAtNTU2Yi00MjM5LWE3YzAtYmI2ZmNkZTg5NGYwIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9