Hi,
I'm trying to add months to my date column. But at this moment it is static
I want that to come from my table called 'Table' and column called Dealy Factor.
So if delay factor is changed to 3 then this will add 3 months to my date
FYI : My delay factor comes from my sharepoint list where the users input the delay factor as a parameter
In my actual dataset this table contains a lot of parameters but for simplicity I have included just the 'Delay Factor'
Find the link of file here
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"
Hey @klehar ,
you can do that in 2 steps:
1. Go to your "Table", do a right click on your number and chose drill down:
2. Instead of a table this query will show a number, also the symbol will change:
3. Then go to your second "Table (2)" and change the fixed number "2" to "Table":
Congratulations, your added date is now dynamically, based on the result of another query 😊
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"
Helpful resources
Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
