Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Return rows whose date are in the future based on current month

Hello,   I have a table that contains data for different items that have expiration dates. I would like to be able to filter the table and show rows whose expiration dates are x months into the fu...
  • eliasayyy's avatar
    eliasayyy
    3 years ago

    for caluclated column 

    Near Expiry = 
IF(
    MONTH(TODAY()) + 3 >= MONTH('Table'[Expiry Date]),
    "Yes",
    "No"
)


    for measure

    Near Expiry Measure = 
IF(
    MONTH(TODAY()) + 3 >= MONTH(MAX('Table'[Expiry Date])),
    "Yes",
    "No"
)

     

     

eliasayyy's avatar
eliasayyy
Memorable Member
3 years ago

for caluclated column 

Near Expiry = 
IF(
    MONTH(TODAY()) + 3 >= MONTH('Table'[Expiry Date]),
    "Yes",
    "No"
)


for measure

Near Expiry Measure = 
IF(
    MONTH(TODAY()) + 3 >= MONTH(MAX('Table'[Expiry Date])),
    "Yes",
    "No"
)