This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. 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.
| User | Count |
|---|---|
| 20 | |
| 18 | |
| 14 | |
| 13 | |
| 13 |
| User | Count |
|---|---|
| 48 | |
| 35 | |
| 24 | |
| 20 | |
| 19 |