Power Query Filter All Rows After Prior Month

Hi All,

I'm looking to create a filter on a dataset in power query editor that returns all rows that are dated in the prior month onwards, the filter syntax currently filters all activity from 1st June onwards, which has manually been selected is

Please Login or Register  to view this content.

I've researched and am unable to amend the syntax to accommodate the a programmable filter, ie, currently in June so filter all rows after 31st may 2018, when in the month of July, filter all rows after 30th June 2018, etc....


Any help would be greatly appreciated

Many thanks

the field is DateTime formatted

Thank you for your help, but I cant seem to get it to work????

Can you give me bit more detail? Such as exact error message (screenshot) that you get when you try to apply the solution.

If above fails, you could always set up single cell named range in Excel sheet and pass that on as variable in M.

Ex: In any cell. =DATE(YEAR(TODAY()),MONTH(TODAY()),0) and name it prevmonth in name manager.
Then in M (using PowerQuery advanced editor)... add following line after "let".

Please Login or Register  to view this content.

Then you can use it like...

Please Login or Register  to view this content.