Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello!
I have a paginated report subscription that I would like to run every day and one parameter is date. I would like the date value to be the todays date, but the default value is set to yesterdays date. I have subscriptions set up for different people that need to use both settings, so I can not just change the default value. Is there a way to support this?
Best,
Callan Garst
Not sure I follow the scenario completely. But, currently, a subscription allows for a single set of parameter values. If you are creating two separate subscriptions, you could add a second parmaeter called "UseToday". Then, based on that value of that parameter, create an expresson that uses today's date. Examples of date expressions are here: https://stackoverflow.com/questions/15940940/how-do-i-display-todays-date-on-ssrs-report
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.