Json to table help

[pablopablo]

Hi, 

I am trying to expand the following json into rows.

So in the image for each 'Name' there are multiple 'actual' values

After this, it expands to this:

Then to:

So each of these epoch times are linked to a room in the first image

I want the data to look like:

6060    1575248400

6060    1575247400

6060    1575525600

6061    1575261900

6061   1575261900

[v-yuta-msft]

@pablopablo ,

Have you tried expanding the value column? If you still don't know how to achieve the result, please shara the sample json file.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Did you click the record or did you click this icon?

Somehow my picture doesnt want to be added to this comment. Here is the link:
https://powerbicdn.azureedge.net/mediahandler/blog/media/PowerBI/blog/b9073b76-96de-4945-bdd0-9fc7ef...