Use table values as a parameter

Hello klehar ,

you didn't say they are in one table 😉

You can just do the drill down for each parameter in the second query.

For your example, I added 2 more columns:

In the "Table (2)" query you can add the drilldown as an own variable, like that:

ParameterDelayFactor = Table{0}[Delay Factor],

Or if you need the Parameter 3:

ParameterParameter3 = Table{0}[Parameter 3],

Then you can add it to your normal query of "Table (2)":

let
    ParameterDelayFactor = Table{0}[Delay Factor],
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtE31DcyMDJQio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "DateAdd", each Date.AddMonths ( [Date], ParameterDelayFactor )),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"DateAdd", type date}})
in
    #"Changed Type1"