Forum Discussion

Jancarlos_Ascen's avatar
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Jancarlos_Ascen

     

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

     

    Cheers

     

    CheenuSing