extrapolation of costs

[DagdasAlbag]

Hello,

can someone please help me with the projection of the costs.

costs=CALCULATE(SUM(costs)) / [Days In The Current Year Until Today] * [Days In Current Year]

costs= CALCULATE(SUM(costs))/321 Days * 365 days in Current Year

[Fowmy · Accepted solution]

@DagdasAlbag 

You can add a column to your table:

Full Year Cost = 
DIVIDE(
    Table1[Cost],
    DATEDIFF(DATE(YEAR(Table1[Date Time]),1,1), TODAY(),DAY)
)
*
 DATEDIFF(DATE(YEAR(Table1[Date Time]),1,1), DATE(YEAR(Table1[Date Time]),12,31),DAY)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[DagdasAlbag]

Hi,

unfortunately I have not received the desired value. The new calculated value must be greater than the actual value.

[DagdasAlbag]

Hi,

i would like to calculate the number of days from 01.01.2020 to the present day. in the following form i get a value in heights of 42.324 instead of 321.

Tage (Aktuel) = DATEDIFF(DATE(YEAR(2020),1,1),TODAY(),day) -->does not work (42.324)

With this formula I get the value I need but I want him to always take today.

DATEIFF(DATE(YEAR(2020),1,1),DATE(YEAR(2020),11,17),DAY)+1 -->this formula works (321)

the blue marked one should always show the current day