Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
Anonymous
Not applicable

New Calculated Column

Hello,

I am needing to create a column to track the end dates of subscriptions. My table already has a start date column and a column for program length, but I need to track an end date using the two columns. Any ideas? New to BI so any help is much appreciated.

 

Thanks!

2 REPLIES 2
vicky_
Super User
Super User

If your program length is in Days (or can be converted to days), then you can simply use the DATEADD function: https://learn.microsoft.com/en-us/dax/dateadd-function-dax

 

Anonymous
Not applicable

I have a start date column in "mm,dd,yyyy" and im needing to create a new end date column in the same table based off of different lenths of a program that we sell. They are in 6, 6 and 12 month incriments. Would the DATEADD still be the best function for this?

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors