Forum Discussion
Relative Date Parameter in Power Query
Is there a way to configure a Parameter in Power Query so that it is RELATIVE (to the current date or date of the refresh)? I have some tables with several million rows and would like to limit it...
ToddChitt,
You can check my reply in this similar thread about how to set up a Query in Parameters. However, if you need to use the parameter to filter rows in tables in query editor, you would need to manually enter current value each day.
In your scenario, I would recommend you add the line #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [Date] > Date.AddDays ( DateTime.LocalNow(), -90 ) ) in each query.
Regards,
Lydia