Incremental calculation with table - Need Help

[Anonymous]

Hello Guys,

Awesome foro,!

need help over here, i got this tables:

Total_mb used_mb  free_mb   Date

20000       1921         18079       1/12/2018

20000        1921        18079       1/12/2018

20000        1800        18200       1/6/2018

20000        1800        18200        1/6/2018

I need to build a graphic with the incremental value of mb between the dates

Thank you!! 🙂

[Thyago_Rezende]

Hi @Anonymous,

you can use the function below:

#for running total over year

Incremental_Sum = TOTALYEAR(free_mb; Date_Table[Dates)

Regards,

[Anonymous]

Hello, 

Sorry for my delay i was out.

Mmm no, i can't run that function. The expresion TOTALYEAR is not working.

The idea would be to select two diferent dates, and then get the substraction btween the same. and use that value in a graphic.

do you got any idea?

[Anonymous]

I tried this solution: 

CumulativeTotal = CALCULATE(Sum(vnxcritical[Used Space GB]),FILTER(ALL(Datesonly[Date]),Datesonly[Date] <= Max(Datesonly[Date])))

but this calculates the cumulative, what i need to express is the diference, that i'm getting from the cumulative, as you can see in this pic