Forum Discussion

GrantC101's avatar
GrantC101
New Member
5 years ago
Solved

previous month last month filter

Hello All   Looking at getting some help with hopefully a simple filter. I have been using the basic filters for Data filtering and have been asked to provide seprate tables for last months and an...
Need Help
  • GrantC101's avatar
    GrantC101
    5 years ago

    I have managed to achieve this using the following;

    each [Date Reported]<=Date.AddMonths(Date.From(Date.EndOfMonth(DateTime.LocalNow())),-2))

     

    thank you for the help

GrantC101's avatar
GrantC101
New Member
5 years ago

Thank you for the quick reply how would I put this into Power Query Editor?

GrantC101's avatar
GrantC101
New Member
5 years ago

I have managed to achieve this using the following;

each [Date Reported]<=Date.AddMonths(Date.From(Date.EndOfMonth(DateTime.LocalNow())),-2))

 

thank you for the help