Forum Discussion

andrea_chiappo's avatar
andrea_chiappo
Icon for Helper III rankHelper III
6 years ago
Solved

add one year to date column

This should be very easy, yet it doens't work   I tried both creating a new column and a new measure to get dates one year  ahead with respect to the date column you see in the attachment.   As y...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    andrea_chiappo 

    As a new column is should have worked. Check are you creating a measure or column

    You can also try a new measure like

    New column = Date(year('TableName'[createdDate])+1,month('TableName'[createdDate]),day('TableName'[createdDate]))

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi andrea_chiappo ,

 

If the dates in the current context do not form a contiguous interval, the function returns an error. See this thread for a more comprehensive explanation.

You can try the formula mentioned in amitchandak .

You can also try this:

LastDate = DATEADD('TableName'[createdDate].[DATE], 1, YEAR)

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • andrea_chiappo's avatar
    andrea_chiappo
    Icon for Helper III rankHelper III
    6 years ago

    Nope, it doesn't allow this operation, saying that:  

    Column reference to 'createdDate' in table 'DimCustomers'cannot be used with a variation 'Date' because it does not have any  

     

     'createdDate' looks like this