Calculated date returns blank when beyond range of input column

[JPM_Oslo]

Hello

I have some data from 2019/2020 that I am trying to 'time/shift' to 2020/2021.

I am trying to do this with a new column called "projected renewal date" with the formula shown.

Problem is, that the formula returns empty when the output is beyond the range of the input date (renewal date)

Below is the result if I add 1 day, or 2 days.

Any help much appreciated!

[amitchandak · Accepted solution]

@JPM_Oslo , If you want add days, You can simply add a number

new date = [date]+1

new date = [date]+2

dateadd will not cross the boundary of available dates .

For month, year or day , you can also try like

new date = date(year([date])+1,month([date]),day([date]))

refer : https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power...

new date = [date]+2

[JPM_Oslo]

Thanks for such a quick response!

That solves the immediate problem 🙂 

Is there a reason what I was trying doesn't work?

[JPM_Oslo]

...aaaand your second post answered my other question.

Thanks so much