How filter table in power query to get all rows where Mydate < last day of previous month?

[aignn]

Hello!

Help me please. How filter table in power query to get all rows where Mydate < last day of previous month?

That possible with Date.EndOfMonth? Like this:

#"Filter1" = Table.SelectRows(#"Filter0", each Date.EndOfMonth(.....))

Thank you advance

[Jimmy801]

Hello @aignn 

were you able to solve the problem with any reply given?

If so, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)

Kudoes are nice too

All the best

Jimmy

[Jimmy801]

Hello @aignn 

try something like this (not tested!)

#"Filter1" = Table.SelectRows(#"Filter0", each [Mydate]< Date.EndOfMonth(Date.AddMonths(DateTime.LocalNow(),-1)))

If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy