I need to filter for All dates after today in a Page

[Jadegirlify]

 I have a today's date column that auto populate today's date.

I need help creating a filter for my power BI report view to only show employees with an expiration date after today's date. I dont want to put a specific date in the filter because today's date will always change. So I need a filter that will always shows data with expiration after today only. I have the option to do an advance filter on page, but it only requires me to enter a specific date instead of using "Today". Is there a filter measure that can possibly be created to show "Expiration Date after Today"?

ID	Name	Expiration Date	Today's Date
00123	Mark Smith	4/30/2024	4/26/2024
00256	Jane Doe	3/15/2024	4/26/2024
01345	James Thomas	12/20/2025	4/26/2024
02123	Amy Lu	1/1/2023	4/26/2024
01232	Sam Adams	2/25/2026	4/26/2024
00129	Ben Toms	4/15/2023	4/26/2024
08127	Tammy Glenns	5/31/2024	4/26/2024

In the table below I want the result to show how many employees with "Expiration Date after Today". The result should look like this:

ID	Name	Expiration Date	Today's Date
00123	Mark Smith	4/30/2024	4/26/2024
01345	James Thomas	12/20/2025	4/26/2024
01232	Sam Adams	2/25/2026	4/26/2024
08127	Tammy Glenns	5/31/2024	4/26/2024

Thanks so much

[Jadegirlify · Accepted solution]

Thanks so much, that helped. How about for "Expiration after 90 days from today?"

[v-xuxinyi-msft]

Hi @Jadegirlify 

You can change Today's Date as follows:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jadegirlify]

After creating this measure Measure = IF(MAX([Expiration Date]) > [Today's Date], 1, 0), I drag the measure into the filter field, it works for the table visual but won't accept it for the card visual. Is there a work around that?

[v-xuxinyi-msft]

Hi @Jadegirlify 

Thanks for the reply from @Wilson_ , please allow me to provide another insight:

First I created a measure to get today's date.

Today's Date = TODAY()

Then I created another measure to determine if the Expiration Date is after today's date.

Measure = IF(MAX([Expiration Date]) > [Today's Date], 1, 0)

Put the measure into the filter so that the visual only shows data where the measure is equal to 1.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jadegirlify]

Thank you, how can i display this on a card visual?

[Wilson_]

Hi Jadegirlify,

Instead of doing an Advanced Filter, pick the Relative Date option and do something like the below. Whether you want to include today or not is up to you.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.