Forum Discussion
use current date in current value of manage parameter
Hi Umair_Aslam01 ,
Current Value in parameter management cannot be set dynamically.
If you want to filter data before loading dynamically, please refer to the following way:
Solved: Dynamic Date Parameter for Import Queries - Microsoft Fabric Community
You do this by creating a query in Power Query and referencing that query when you type SQL Statement into the connector.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution SageAre you doing import or direct query? In any case, you wouldn't use a parameter for that. Either use the pulldown on your date column and choose one of the date filters there (e.g., is in previous 1 day), or use Date.From(DateTime.LocalNow()) to get today's date dynamically in the formula bar.
Pat
I am using direct query and binding the parameter with the date column and the parameter wants the initial (default) value. I want to you their current date.
I am trying to use if condition in advance query but not get sucess yet.
How were you able to achieve this? I tried using the measure to filter for the latest date, but it doesn't allow any filter when the date is binded to a parameter.