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])
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?