Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

filter date field by a dynamic date

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.

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@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.

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@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

@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.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@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
Not applicable

@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.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.