Pulling data from last 6 months

[MirandaJ]

Hi, I've created a query that will retrieve data from SharePoint and then will create a dashboard with that data. However, this dashboard eventually will be huge and I only want to retrieve the last 6 months of data, including today's date, starting from a column called Admission Date.

For example, a row on any given file on that SharePoint has X Admission Date, so if that date is beyond 6 months from today, that data will not be pulled into my dashboard. Hence, everything with an Admission Date within 6 months from today, will be pulled.

The caveat here is that TODAY's date will always be dynamic.

Sorry I cannot provide my dashboard since it's confidential data

[vicky_ · Accepted solution]

If you go into PowerQuery, there's an option to just load data that is from the last n months.