Forum Discussion
Json to table help
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
2 Replies
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-9fc7ef8325a4.png
v-yuta-msftCommunity Support
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.
