Query last N days of a dataset with user input

[Anonymous]

Hi,

I currently have a huge dataset of google analytics data that I am using as a data source in power BI. Currently, I am filtering the date manually which gives this query:

= Table.SelectRows(#"Added Items", each [Date] >= #date(2021, 11, 22))

What I want to do is allow the user to choose the date that the data starts, which then loads the data from the correct range. However, I don't want the report to load the entire dataset as the dataset has >20,000 rows.

I am trying to approach this problem by using power BI parameters with a default value that isn't too long ago, and use a list of suggested values from a query that lists dates in specific intervals, e.g., 10, 20, and 30 days ago from the current date, etc. I would then filter the date column in the dataset to be on or after the specified parameter value, but I'm not sure how to go about this as I am pretty new to Power BI. 

Any help is greatly appreciated.

[AllisonKennedy]

@Anonymous  You're absolutely on the right track. Have you created the parameter already? Have you generated the query with the list of values? Which step do you need help on? 

[Anonymous]

@AllisonKennedy 

I'm glad to hear that I'm on the right track. I've created the parameter with a single value as a placeholder, which does work to filter the data. However, I don't know how to create this query which lists multiple dates from N days before the current date.

[AllisonKennedy]

@Anonymous  This function Date.AddDays might help: https://docs.microsoft.com/en-us/powerquery-m/date-adddays

If you can provide sample files I can give more specific help... (sorry for the long delay, took a bit of time off 🙂 )