topic Expiring date greater than "today" in DAX Commands and Tips

Expiring date greater than "today"

Anonymous — Tue, 09 Aug 2022 23:00:54 GMT

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

Re: Expiring date greater than "today"

amitchandak — Wed, 10 Aug 2022 03:22:47 GMT

Anonymous ,

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

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

Re: Expiring date greater than "today"

Anonymous — Wed, 10 Aug 2022 10:27:26 GMT

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?

Re: Expiring date greater than "today"

v-cazheng-msft — Tue, 23 Aug 2022 07:12:04 GMT

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

Re: Expiring date greater than "today"

Anonymous — Tue, 23 Aug 2022 16:30:05 GMT

Hi there.

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

Best,

Dielson