Forum Discussion
Calculation in Data View - Year doesn't change
Hello everyone, 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 - wh...
Anonymous Try this:
BudgetEnd=DATE(YEAR(Table[Date]), MONTH(Table[Date]),DAY(Table[Date]))+[ForecastDurationDays]
Anonymous Try this:
BudgetEnd=DATE(YEAR(Table[Date]), MONTH(Table[Date]),DAY(Table[Date]))+[ForecastDurationDays]
Thank you so much! Didn't know the solution is that simple š