Help Needed Power Query Custom Column to Identify Last Month

[julie_bunavicz]

Any suggestions on creating a custom column to identify data for last month?  

Date table shown below.  If the currenly in October 2023.  I would like to see only data from September 2023 to today.  This should be dynamic from month to month.

This effort is to reduce the number of rows queried, improve performance.

Thanks!!

Julie Bunavicz

[julie_bunavicz]

That works nicely.  Thanks!!

[rsbin · Accepted solution]

@julie_bunavicz ,

Here is one method that should work for you. Create a CustomColumn:

Date.IsInPreviousNMonths( [Date],1) or
    Date.IsInCurrentMonth( [Date] )

Then apply a Filter for "True"

Hope this works for you.

Regards,