Previous months data

[JSheppard98]

Hi there,

Having some issues currently with managing to use formulas/filters in Alteryx to get all of the previous month's data when ran (running on 5th Jan 23, would pull through all of Dec 22's data). This file pulls through all the previous months data so would include Oct22, Nov22, Dec 22 etc. And would like to just grab all of the data from the entire previous month from the "run month" if that makes sense please?

The example data format would be like below for simplicity, in practical use with more rows.

[binuacs · Accepted solution]

@JSheppard98 One way of doing this

Another way of doing this is by comparing only the year/and  month

[JSheppard98]

That's perfect thank you so much, far simpler than I had thought. Many thanks!