Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Comparing dates from two different tables

I have 2 tables, the first contains all the transactions(TransactionTable) and the second one contains all the dates (DateTable) from 1st Jan 2018 to 31st Dec 2021.   I have a expired date for each...
Need Help
Show and Tell
Tips and Tricks
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

Shouldn't the expiration date of the product be compared with today?

__DateDiff = 
DATEDIFF(
    TODAY(),
    MAX(Sheet1[expiration_date]),
    DAY
)
__Number of expiration = 
CALCULATE(
    COUNT(Sheet1[Product_id]),
    FILTER(
        Sheet1,
        [__DateDiff] < 0 
    )
)

 

Best regards,
Lionel Chen

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

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

Has your problem been solved?

 

Best regards,
Lionel Chen

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