Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Only incremental values - Calculate between dates

Hi Guys,

 

this might look simple.. but dk how to do it

this is the information:

 

 

 

 

So.. i got the Cumulative Total using this function:

 

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

 

But what i need is to get the differences between the dates, in the first date and the second the difference will be of 210. I need to get another column with that information. know the formula to do that?

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Effectively what you want is the value for that day only.  Do you get the correct answer with this?

     

    =SUM(vnxcritical[Used Space GB])

     

4 Replies