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 today.  This should be dynamic from month to month.

 

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

 

 

Thanks!!

 

Julie Bunavicz

 

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,

2 Replies

  • 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,