Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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!
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
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?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 27 | |
| 23 | |
| 18 | |
| 18 | |
| 15 |
| User | Count |
|---|---|
| 49 | |
| 44 | |
| 42 | |
| 39 | |
| 32 |