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 nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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?
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 20 | |
| 11 |
| User | Count |
|---|---|
| 62 | |
| 55 | |
| 47 | |
| 45 | |
| 35 |