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 id...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    Expiration Date =EDATE('LCD Program Tracking'[Start date],[Program Length])
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?