Forum Discussion
Extract multiple dates as rows from JSON field
Hello PowerBI community, I could not find an answer anywhere on the forum, I am trying to extract dates and an associated values from a JSON field. For each row, I have one or muliple dates with...
Hi Anonymous
OK, you can extract the date and corresponding value using this query instead
let Source = { [#"2021-02-13" = 7.08333333], [#"2021-03-13" = 7.08333333], [#"2021-04-13" = 7.08333333] }, #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Added Custom1" = Table.AddColumn(#"Converted to Table", "Date", each Record.FieldNames([Column1]){0}), #"Added Custom" = Table.AddColumn(#"Added Custom1", "Value", each Record.Field([Column1], Record.FieldNames([Column1]){0})) in #"Added Custom"Regards
Phil
Hi Anonymous
Download sample PBIX file with the following example.
If you have a column of Records you should be able to expand these using the double headed arrow in the column header
Which will give you something like this
You can then unpivot the columns to give you this
Regards
Phil