Forum Discussion
use current date in current value of manage parameter
Hi everyone!
I am trying to use date parameters in the Power BI direct query but I am facing a problem. Can anyone help me to overcome it?
It is about the use of the current date in the current value of the manage parameter.
I am binding the date with the date parameter but it want one value that is used on the first time loading of the report. I want to use current date in the current value tha first time it should run current date automatically.
Can anyone help me.
Thanks.
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.
4 Replies
ppm1Solution Sage
Are 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.
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.
