Forum Discussion
Dynamic parameter, automatic update based on today's date
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.
2 Replies
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.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