Calculate expire date

[selected_]

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?

[challoran87]

Which visualization did you use? 

[v-shex-msft]

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

[VijayP]

@selected_ 

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

[pranit828]

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

[selected_]

@pranit828 

your calculation show blank

[NilR]

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')