Only incremental values - Calculate between dates

[Anonymous]

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?

[Ashish_Mathur · Accepted solution]

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])

[Greg_Deckler]

I have a Quick Measure here that might help, it is a very similar issue:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Revenue-Reverse-YTD/m-p/373185

[Anonymous]

Hey, thanks for help.

I try your solution.. like this:

don't know why is that number 47753154322 it's in all the columns. it's strange. do you have any clue ? :s

[Anonymous]

Hi @Anonymous

Greg_Deckler's solution is a measure, why you direct input measure formula into a calculated column? 

Calculated Columns and Measures in DAX

Regards,

Xiaoxin Sheng