Forum Discussion
Calculate expire date
I have products with that are coming with expire date I want
How is this measure made that amount products that expering <30 days like those below?
6 Replies
Hi selected_
Use the below measure to get teh days left.
Days_left = DATEDIFF(selectedvalue(table[expire_date]),TODAY(), DAY)
Now for each of these charts use filter condition on days left as
1. Less than or equal to 30
Less than or equal to 60 and greater than 30
Less than or equal to 180 and greater than 60
greater than 180
Anonymous
your calculation show blank
You need two measures OR combine intoone. one to calc the expired date them put into if statement:
Days between = DATEDIFF(table[date],TODAY(), DAY)
DATEDIFF (<start_date>, <end_date>, <interval>)then with If stament
IF([Days between]>= 30, "YES","NO')
https://www.youtube.com/watch?v=3bV9BfB3_Oc&t=1s Watch this video to create Ageing of the Expiry Date and you can easily monitor the products Expiry Date
If you find this solution as you require then mark this as solution and share your Kudoes
Vijay Perepa
Hi selected_,
Please provide some dummy data and expected results to help us clarify your scenario, then we can test to coding formula on it.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Which visualization did you use?
