Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Calculating Expiry Date

    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
    Posted Dec 19, 2022 03:04 AM
    Use the DateDiff function :

    DATEDIFF function (DAX) - DAX | Microsoft Learn

    ------------------------------
    James Watts
    Business Intelligence Analyst
    ------------------------------