Expiring date greater than "today"

[Anonymous]

Hi,

I am a brand new Power BI user.

Could you please help me create a measure to get as a result only expiration dates greater than "today"?

Thanks

[v-cazheng-msft · Accepted solution]

Hi @Anonymous,

You could try this measure.

ExpectedRes = CALCULATE(MAX('Table'[ExpDate]),FILTER('Table',MAX('Table'[ExpDate])>=TODAY()))

Then, the result looks like this.

Attached the pbix file as reference.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,    

Community Support Team _ Caiyun

[Anonymous]

Hi there.

Thank you, very much for your help.
You suggestion worked very well!

Best,

Dielson

[Anonymous]

Hi again.

Thanks for your reply.

Unfortunately, it is not working:

I would like the results to show the all the product's expiration dates only when they are greater than "today".

I tried your suggestioned solutions but I got no data as results. I might have used them in a wrong way.

Eg.: if today is 08/10/2022 

This is the matrix I would like to get:

Product	ExpDate	Expected results in the column
1	09/20/2027	09/20/2027
2	01/08/2023	01/08/2023
3	12/25/2020	This row should not appear on the matrix
4	04/12/2025	04/12/2025

Could you give me a hint?

[amitchandak]

@Anonymous ,

countrows(filter(Table, Table[exp Date] > today() ) )

or

calculate(count(Table[Value]), filter(Table, Table[exp Date] > today() ) )