FROMCSV 12-27-2022 14:46 PM - last edited 12-27-2022 15:02 PM

[Greg_Deckler]

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