Dynamic parameter, automatic update based on today's date

[Anonymous]

Hi, 

Is it possible to make a parameter value change automatically based on date criterias maintained in a separate list?

criteria	parameter value
<5/15/2021	4/1/2021
<6/15/2021	5/1/2021

The parameter value would be dependant on today's date. 

If todays's date is before 5/15/2021 the parameter value is 4/1/2021 and when today's date changes to 6/15/2021 the parameter value changes to 5/1/2021.

[Anonymous]

@Anonymous 

Sounds like you want the most recent 45 days. You may refer to my recent blog:
Dynamically Display the Most Recent N Days using P... - Microsoft Power BI Community

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous 

Thanks for your reply, it was however not the solution I was aiming for.

For each month I want to replace the forecast numbers in my data with actual numbers on the dates given in the list. I do this by changing the parameter value each month via Edit Parameter, but I was hoping for solution that the Parameter automatically can retrieve the correct value based on today's date.

Br,

Chris