converting text into columns and rows

[Housny]

hello,

i need to create columns and add the value from a specific text

this is the model of the text i have

[{"Date":"2023-12-18T00:00:00","Percentage":50.0},{"Date":"2023-10-11T00:00:00","Percentage":25.0},{"Date":"2024-10-11T00:00:00","Percentage":25.0}]

i need to convert it like this

[Housny]

thnaks

[spinfuzer · Accepted solution]

It is a Json.

Put Json.Document( ) around your text. It might look something like add a custom column =Json.Document([Column1]) or potentially around your source step.