Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all, pretty much new here, tried searching for an aswer for this. I got query from http://api.bitcoincharts.com/v1/weighted_prices.json and it gives me a table like one in the picture. I would like column values to separate by columns keeping headers 7- 30 and 24h,
What did I miss, I keep getting errors when trying to unpivot/split?
Solved! Go to Solution.
The timestamp value can't be expanded, so I would suggest to delete it.
let Source = Json.Document(Web.Contents("http://api.bitcoincharts.com/v1/weighted_prices.json")), #"Converted to Table" = Record.ToTable(Source), #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each ([Value] <> 1511644685)), #"Expanded Value" = Table.ExpandRecordColumn(#"Filtered Rows", "Value", {"7d", "30d", "24h"}, {"7d", "30d", "24h"}) in #"Expanded Value"
The timestamp value can't be expanded, so I would suggest to delete it.
let Source = Json.Document(Web.Contents("http://api.bitcoincharts.com/v1/weighted_prices.json")), #"Converted to Table" = Record.ToTable(Source), #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each ([Value] <> 1511644685)), #"Expanded Value" = Table.ExpandRecordColumn(#"Filtered Rows", "Value", {"7d", "30d", "24h"}, {"7d", "30d", "24h"}) in #"Expanded Value"