Forum Discussion
Assistance with Dynamic Parameters in Power Query
Hi,
Thanks for the solutions Omid_Motamedise ， KNP and Vijay_A_Verma offered, and i want to offer some more information for user to refer to.
hello Pavan_123456789 , as the users mentined, if you use the paramater , you cannot input code in "Current value",you need to input the date.
If you want to use the code, you need to set the parameter in Advanche de Eddito separately and then reference it, you can refer to the code.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMtY31DdUitWBckz1TWAcEyDHDMEx1DdF4hjqGynFxgIA", 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}}), Rangestart=Date.From(Date.StartOfYear(DateTime.LocalNow())), Rangeend=Date.From(DateTime.LocalNow()), FilterRows=Table.SelectRows(#"Changed Type",each ([Date]>=Rangestart) and ([Date]<=Rangeend)) in FilterRowsBest Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Couple of notes, avoid using Range Start/End if there's any chance you may want to do incremental refresh.
RangeStart and RangeEnd are reserved for that purpose.
That aside, it would be good to see how you've created the parameters and what you're comparing it to.
It could be that you're comparing datetime to date, which you can't do.
It could be that the parameter is not setup correctly. Need some more info.
Also, for start of current year, I think you'll want...
= DateTime.From(Date.StartOfYear(DateTime.LocalNow()))
Hi KNP ,
Thank you for your prompt response.
I wanted to clarify that the Range Start and Range End parameters are essential and cannot be omitted under any circumstances. I am comparing the data specifically with the date, and even using the date format is acceptable.Parameters also required in dates only not required the time .