Incremental calculation with table - Need Help

Question

Hello Guys,&nbsp;Awesome foro,!need help over here, i got this tables:&nbsp;&nbsp;Total_mb used_mb&nbsp; free_mb&nbsp; &nbsp;Date&nbsp;20000&nbsp; &nbsp; &nbsp; &nbsp;1921&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18079&nbsp; &nbsp; &nbsp; &nbsp;1/12/201820000&nbsp; &nbsp; &nbsp; &nbsp; 1921&nbsp; &nbsp; &nbsp; &nbsp; 18079&nbsp; &nbsp; &nbsp; &nbsp;1/12/201820000&nbsp; &nbsp; &nbsp; &nbsp; 1800&nbsp; &nbsp; &nbsp; &nbsp; 18200&nbsp; &nbsp; &nbsp; &nbsp;1/6/201820000&nbsp; &nbsp; &nbsp; &nbsp; 1800&nbsp; &nbsp; &nbsp; &nbsp; 18200&nbsp; &nbsp; &nbsp; &nbsp; 1/6/2018&nbsp;&nbsp;I need to build a graphic with the incremental value of mb between the dates&nbsp;Thank you!! :)&nbsp;

thyago_rezende · Answer

Hi&nbsp;Anonymous,&nbsp;you can use the function below:&nbsp;#for running total over yearIncremental_Sum = TOTALYEAR(free_mb; Date_Table[Dates)&nbsp;Regards,

anonymous · Answer

Hello,&nbsp;&nbsp;Sorry for my delay i was out.&nbsp;Mmm no, i can't run that function. The expresion TOTALYEAR is not working.&nbsp;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 · Answer

I&nbsp;tried this solution:&nbsp;&nbsp;CumulativeTotal = CALCULATE(Sum(vnxcritical[Used Space GB]),FILTER(ALL(Datesonly[Date]),Datesonly[Date] &lt;= Max(Datesonly[Date])))&nbsp;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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Incremental calculation with table - Need Help

3 Replies

Related content

Increment Refresh

Incremental refresh

Direct Lake Model - Calculated Column/Tables

Incremental Refresh

Incremental Refresh on Dataflow sourced from SharePoint