a new column if one of several columns are "expired"

[lynnzrae]

I would like to create a formula that reports out that a permit is expired if at least one of five columns below return an "expired" value.

Permit is expired = 

180 days till start expiration	Start Date	180 Days until end expiration	End Date	Extension Date
safe from expiration	not expired	expired	expired	Not applicable
expired	expired	safe from expiration	not expired	Not applicable
nearing expiration	not expired	safe from expiration	not expired	not applicable
safe from expiration	not expired	nearing expiration	not expired	Not applicable
safe from expiration	not expired	expired	not expired	expired

Thank you

[Anonymous · Accepted solution]

Thanks for the reply from bhanu_gautam , please allow me to provide another insight: 
Hi  @lynnzrae ,

Here are the steps you can follow：

1. Create calculated column.

Way =
var _table=
UNION(
    DISTINCT('Table'[180 days till start expiration]),
    DISTINCT('Table'[Start Date]),
    DISTINCT('Table'[180 Days until end expiration]),
    DISTINCT('Table'[End Date]),
    DISTINCT('Table'[Extension Date]))
return
IF(
    "expired" in SELECTCOLUMNS(_table,"Test",[180 days till start expiration]),"expired")

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[bhanu_gautam]

@lynnzrae , You can create a new measure using

DAX
PermitExpired =
IF (
OR (
[180 days till start expiration] = "expired",
[Start Date] = "expired",
[180 Days until end expiration] = "expired",
[End Date] = "expired",
[Extension Date] = "expired"
),
"Expired",
"Not Expired"
)

[lynnzrae]

Is there a formula for a new column vs a measure.  It doesn't want to do a measure b/c the 5 columns I am pulling from are based off of formulas.