Date End Date from Start Date Column

[Anonymous]

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)

[Ritaf1983]

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]

Hi there,

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

[Anonymous]

That worked! Thank you so much!

[Ahmedx · Accepted solution]

pls try this

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

[Anonymous]

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]

That worked! Thank you so much!