Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Date End Date from Start Date Column

Hello,

I am trying to calculate an end date column for a program based off a start date column and a program lenght column. Below is the DAX I am using. It pulls over some dates, but not all. Any ideas?

 

Expiration Date = DATEADD('LCD Program Tracking'[Start date],[Program Length],MONTH)
 

 

 
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    Expiration Date =EDATE('LCD Program Tracking'[Start date],[Program Length])

6 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous 
    Datedadd doesn't work for the overlapping year.

    Please update the formula to :

    end date = EDATE('Table'[start date].[Date],[program lenth])
    PBIX is attached

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi there,

      I am drawing a blank. My current lenght column is in months. How do I update it to calculate by weeks?

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    pls try this

    Expiration Date =EDATE('LCD Program Tracking'[Start date],[Program Length])
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      That worked! Thank you so much!

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I am drawing a blank. It is calculating my new expiration date column correctly. However, I am wanting the length to be in weeks instead of months. How would I change that?

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    That worked! Thank you so much!