Calculating Expiry Date

Calculating Expiry DateFollow
Aadish Shah
Aadish ShahDec 18, 2022 08:24 PM
Hi! I need some assistance on calculating a Expiry date: 2 years from the order date . Examples: …
1. Calculating Expiry Date

Aadish Shah
Posted Dec 18, 2022 08:24 PM
Hi!

I need some assistance on calculating a Expiry date:
2 years from the order date.

Examples:
– order date January 1st 2020 – Expiry date January 1st 2022

I’m struggling hard on how I would calculate this out.

Thanks!

——————————
Aadish Shah
——————————

2. RE: Calculating Expiry Date

Bronze Contributor
James Watts
Posted Dec 19, 2022 03:04 AM
Use the DateDiff function :

DATEDIFF function (DAX) – DAX | Microsoft Learn

——————————
James Watts
Business Intelligence Analyst
——————————