need a measure that compares dates and display status, Expired, Not Expired and Close to Expiry

[Anonymous]

hello Team,

I need to perform a measure in Powerbi that compare dates and give me results (Expiry Status)
A. Expired Status; Compare todays date with Expiry date field and display Status
B. Close to Expiry; Compare todays date against a field (Number of days to expire) and display status (Close to Expirey /Okay Not expired)

Since this is perishable stock, there is a table with field that has entered with number of days to warn before expiry and this
is important to factor when building this measure. 

thank you so much 

[jthomson · Accepted solution]

I'm assuming that you've got some sort of relationship between your stock table and the table that holds your expiry warning cutoff times, one approach would be to:

- pull in the number of days that relates to that stock item as a variable

- use that number with TODAY() to work out when your warning date is

- make a nested if statement, seeing first if today's after the expiry date, then assigning a status of expired if it is, else seeing if today is after the warning date, then assigning a status of close to expired, otherwise not expired