Forum Discussion

franorio's avatar
franorio
Helper III
9 years ago
Solved

Time intelligence add months to a given date

Hello everybody,   got a question, is it possible to add/sum time to a given date? Got my report working with a Dim Calendar Table. Long story short,  I need always to have added 3 months to each ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi franorio,

    Please try the function Dateadd function, here is the link: https://msdn.microsoft.com/en-us/library/ee634905.aspx.

    You can also use the formula to create a calculated column.

    Column = DATE(YEAR('Test1'[Date]),MONTH('Test1'[Date])+3,DAY('Test1'[Date]))


    I use my sample data and get the expected result, please see the following screenhot. Then you can use the new date to create visual.



    Thanks,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi franorio,

Please try the function Dateadd function, here is the link: https://msdn.microsoft.com/en-us/library/ee634905.aspx.

You can also use the formula to create a calculated column.

Column = DATE(YEAR('Test1'[Date]),MONTH('Test1'[Date])+3,DAY('Test1'[Date]))


I use my sample data and get the expected result, please see the following screenhot. Then you can use the new date to create visual.



Thanks,
Angelia

laodc's avatar
laodc
New Member
3 years ago

It is unfortunate that this solution comes up as the first option when searching for this topic.  If you had included an example with a source date in November you'd notice that a date with month number 14 can't exist.