power query filter date

[Jancarlos_Ascen]

Please help in Power Query

I have a database from 2015 - 2018, my problem that when importing from SQL Server takes a long time to update data, I in my dashboard only use the current month, the last month, the same month but 1 year, the same month but 2 years ago, the same month but 3 years ago.

My idea is to put a filter in Power Query so that it only filters the information of the months that I need, and my problem is to filter automatically the months of the years ago, I only have this advance, I do not know what to use, something like in dax this PARALLELPERIOD I do not know what formula is in M ​​language

I have only this

Fecha facturación  it's my column

 = Table.SelectRows(#"Tipo cambiado", each Date.IsInCurrentMonth([Fecha Facturación]) 
or Date.IsInPreviousNMonths([Fecha Facturación], 12))

[Anonymous]

Hi @Jancarlos_Ascen

Can you share sample data in OneDrive or GoogleDrive and post the link here to find a solution.

Cheers

CheenuSing