Filter data of last three months in power query

[Mai_Nashaat]

Hi everybody,

I've loaded data from folder and combined all files together this excel files are automatically generated report three times daily.

I want to get only the last three months and the last generated report in day (it's about 9 or 11 pm)

this snapshot of the data.

@edhans 

@ImkeF 

[v-yingjl · Accepted solution]

Hi @Mai_Nashaat ,

You can try this query to filter rows:

= Table.SelectRows(#"Changed Type", each Date.IsInPreviousNMonths([Date created], 3) and Time.Hour([Date created]) >= 21 and Time.Hour([Date created])<= 23)

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

@Mai_Nashaat use the built in date filter:

1. Click on the date dropdown
2. Date Filters
3. In the Previous

Then pick the month range you want.

Then expand/combine the data files.