Issue with setting Date filter for: Most recent two months in a column

[Anonymous]

Hi all,

I'm trying to let powerbi run some things for me but running into the following issue.

I want to see data for all dates in one column, excluding the first and second months in that column.

Example:

My column contains:

August 2018

October 2018

November 2018

December 2018

January 2019

February 2019

March 2019 

and probably some more.

Now I want to continue, using all data from November onwards... How can I exclude August / October going forward in my measure, in such a way that I can use it on different data sets too, and it would exclude the first two months of any data set. 

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

In Query Editor mode, sort the [Date] with ascending order, then, add an index column in Query Editor mode. Filter the index column to make it to be greater than 2.

Remove the index column.

Best regards,

Yuliana Gu