New Calculated Column

Anonymous · ‎10-31-2023

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!

vicky_ · ‎10-31-2023

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 · ‎11-02-2023

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?