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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
diskovered
Helper III
Helper III

Remove future date from relative date filtering

I'm using relative date filter to show data: is in this, year

 

Page Level Filters.PNG

How do I exclude future dates from here? Thanks

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @diskovered 

The video shared by calerof is helpful.

For your secenario, you could create another measure, then put it in the visual levle filter

Measure = IF(MAX('Table'[Date])<=TODAY(),1,0)

15.png

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
msimmonsmcse
Helper I
Helper I

Problem with this accepted solution is that it can only be used at the visual level. I used the same code, only in a calculated column in my date table. It can be used a filter for a page, all pages or visual:

 

Date-Filtered = IF ( 'Table'[Date]'<=TODAY(), 'Table[Date]', BLANK())

The BLANK() function makes sure there is no value in the column for furture dates in table. 

thanks for adding your thoughts. This was exactly what I needed in order to filter on pages for CY and PY but still allow my date table to have years in the future for forecasting 🙂 

Thank you @msimmonsmcse  just what I was looking for!

v-juanli-msft
Community Support
Community Support

Hi @diskovered 

The video shared by calerof is helpful.

For your secenario, you could create another measure, then put it in the visual levle filter

Measure = IF(MAX('Table'[Date])<=TODAY(),1,0)

15.png

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

calerof
Impactful Individual
Impactful Individual

Hi @diskovered ,

 

You might find this Patrick's Guy in a Cube & @marcorusso's video useful:

 

Cheers,

 

Fernando

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.