Here is a screenshot of my data in the Power Query Editor. I am new to this program so please bear with me.
I added a bunch of json files from Azure Blob Storage as a data source and then I pressed "combine files". This is the result. My goal is to create a line chart that shows power over time. As you can see, I the leftmost column shows the name of the file, while the middle column shows the name of the variables saved in the file and the rightmost one has the values.
I want to have the "date" values on the X-axis and the "power_mw" values on the Y-axis of my line chart. I assume for that I have to create a column with the date values and another column with the power values, but this is what I get when I press "combine files" and I don't know how to edit it. Can anyone offer some help?