Forum Discussion

julie_bunavicz's avatar
julie_bunavicz
Frequent Visitor
2 years ago
Solved

Help Needed Power Query Custom Column to Identify Last Month

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 toda...
Need Help
  • rsbin's avatar
    rsbin
    2 years ago

    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,

rsbin's avatar
rsbin
Community Champion
2 years ago

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,