Forum Discussion
Expiring date greater than "today"
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
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
4 Replies
v-cazheng-msftCommunity Support
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
- amitchandak
Super User
Anonymous ,
countrows(filter(Table, Table[exp Date] > today() ) )
or
calculate(count(Table[Value]), filter(Table, Table[exp Date] > today() ) )
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?
