Forum Discussion
power query filter date
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))
1 Reply
- AnonymousNot applicable
Can you share sample data in OneDrive or GoogleDrive and post the link here to find a solution.
Cheers
CheenuSing