Forum Discussion

Laveigo1's avatar
Laveigo1
New Member
1 year ago
Solved

Power Query Editor Date Filter 2 quarters prior but not the prior quarter

Hi   I am trying to filter my data to only show data from 2 quarters prior from today (e.g. April to June) but not the prior quarter's data (July to September). Is there a way to do so? At the mome...
Need Help
  • BA_Pete's avatar
    BA_Pete
    1 year ago

    Hi Laveigo1 ,

     

    You can try using your current filter, but also excluding the prior quarter at the same time, something like this:

    Table.SelectRows(
    PreviousStepName,
    each Date.IsInPreviousNQuarters([date], 2)
        and not Date.IsInPreviousNQuarters([date], 1)
)

     

    Pete

Omid_Motamedise's avatar
Omid_Motamedise
Icon for Super User rankSuper User
1 year ago

you can add another condition and neglect value in the previous quarter by rewriting your formula as:

 

= Table.SelectRows(#"xxx", each Date.IsInPreviousNQuarters([date],2) and not Date.IsInPreviousNQuarters([date],1))