filter date field by a dynamic date

[Anonymous]

Hi Gurus, 

I am using PowerBI dataset to create my end user reports (Get data > PowerBI datasets).

When I create the powerbi dataset I need to restric some on the data based on a dynamic date filter (from Filter Pane).

The condition is as below

BASIC_START_DATE > CURRENT_DATE - 4 MONTHS.

is this condition possible from filter pane? ther should be a way. Or would I have to create a measure to filter out, if that is the case what is the measure and how do I use it in the Filter pane.

Thanks heaps.

[Greg_Deckler]

Wow @Anonymous I literally just posted the general solution to this problem today to the Quick Measures gallery. You are looking for what I refer to as a Complex Selector:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/td-p/1116633

[Anonymous]

@Greg_Deckler ,

Hi mate, based on your guide I manged to get the date I want to filter the dataset (using FIlter Pane). 

below is the measure I created.

ReportFilterDate =

VAR currdate = TODAY ()

VAR montsback = 4 * 30.5

VAR Result = currdate - montsback

RETURN

Result

Did you know how do I implement this filter in the Filter pane to satisfy below conditon.(BASIC_START_DATE is a date column in one of the tabels of my datamodel).

BASIC_START_DATE > ReportFilterDate.

It seems like I cannot use filter pane

[Greg_Deckler]

@Anonymous - No, I do not know how to use the Filter Pane to do that unless you created a measure for returning 1 or 0, True or False, etc. But, the exact implementation depends on the visual.

[Anonymous · Accepted solution]

@Greg_Deckler  Managed to include a column in the dataset extarct, I think that is the only way, You cannot do it in a measure.

Thanks for the direction.

[Anonymous]

@Greg_Deckler  I need to filter the whole report based on this condtion. 

I will try to get a measure that retuns 0 or 1 and then filter out from the filter pane. 

Thanks mate.