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 😉
Thanks for the suggestion. That was one of my original "tries" - but it only will work if the previous month is 30 days and if I run it on the 1st of the next month 😯. I am looking for something that behaves like the Slicer Month (Calendar), but I will also look at the Expressions in Paginator that you mentioned - appreciate the advice.