Calculation in Data View - Year doesn't change

Question

Hello everyone,&nbsp;this is my first time posting here. I have a data set with 5 tables, it about budget planning and forecasting.The following table should give an overview about the deadline - when will the budget be used up? (in column "BudgetEnd").If there is no forecast duration (this is a calculation which depends on another table, so ignore it here), then the value for "ForecastDuration" is empty - means the budget is already used up.I calculated "BudgetEnd" like this:DATE(YEAR(Table[Date]), MONTH((Table[Date])+Table[ForecastDurationDays]),DAY(Table[Date]))The table looks like this (sample):Order numer | Date&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| ForecastDuration Days | ForecastDuration Months&nbsp;| BudgetEnd56456457&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 01. Aug 2020 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;01. Aug 202083573575&nbsp;&nbsp;&nbsp; &nbsp; | 01. May 2021 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 148&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;| 01. Sep 202138757585 &nbsp; &nbsp;&nbsp;|&nbsp; 01. Aug 2021&nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 168 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 01. Jan 2021This is my problem -&gt; if the Budget ends in the next year (2022), the year still doesn't change (2021) in my table.&nbsp;What do I have to change in the calculation?&nbsp;Best regards&nbsp;Meri

anonymous · Accepted Answer

Anonymous&nbsp;Try this:BudgetEnd=DATE(YEAR(Table[Date]), MONTH(Table[Date]),DAY(Table[Date]))+[ForecastDurationDays]

Forum Discussion

Calculation in Data View - Year doesn't change

2 Replies

Related content

Calculate YoY change

MoM calculation

Calculating Quarter over Quarter Change

Calculate % Change

Calculation Help