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

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
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