Forum Discussion
How to convert a query to a parameter?
Hi everyone, I have two queries A and B, query A is my main data source and query B is a json file that I use for both power BI and a python application we use here. I would like to know how I ca...
I put it together in one query, but I think it demostrates the idea:
let B = let Source = "{""a"":1}", Use = Json.Document("{""name"":""John"", ""age"":30, ""car"":null}")[age] in Use, A = let t = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjRQitWJVjKCUMYQygRIxQIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Ages = _t]), #"Filtered Rows" = Table.SelectRows(t, each (Number.From([Ages]) = B)) in #"Filtered Rows" in AAbove query B returns a number (age) from the JSON string and then query A refers to query B (essentially, uses the number it returns) to use as a filter.
Cheers,
John
Greg_Deckler I did as indicated, but my parameter is empty.
I would like that single item in the list to become the value of my parameter.
Is it possible to do this?
I put it together in one query, but I think it demostrates the idea:
let
B =
let
Source = "{""a"":1}",
Use = Json.Document("{""name"":""John"", ""age"":30, ""car"":null}")[age]
in Use,
A =
let
t = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjRQitWJVjKCUMYQygRIxQIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Ages = _t]),
#"Filtered Rows" = Table.SelectRows(t, each (Number.From([Ages]) = B))
in #"Filtered Rows"
in AAbove query B returns a number (age) from the JSON string and then query A refers to query B (essentially, uses the number it returns) to use as a filter.
Cheers,
John