Forum Discussion
Using a relative date as a parameter in Paginated reports
I need to schedule exports of reports in excel/csv to external vendors and partners. These reports are sent at the beginning of each monthly with the prior month’s data as an excel sheet attachment t...
My solution was to create another column called Prior Month and then populate it with the Power Query function of =Date.IsInPreviousMonth([DATE FIELD]). I then use a filter/parameter where that column = Y. Not the path I thought, but it works...for now 😉
Jon-Heide
Microsoft Employee
Microsoft EmployeeYou could try setting the value of the parameter to an expression. Something like:
=DateTime.Now().AddDays(-30)