Creating a new column with the value from the previous days values.

[Pquinlan21]

[Anonymous]

Hi @Pquinlan21 ,

Have you solved your problem? If solved please mark the reply in this post which you think is helpful as a solution to help more others facing the same problem to find a solution quickly, thank you very much!

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pquinlan21]

I want to calculate the total for the day by subtracting the previous days total minus the current days total

[CoreyP]

So, you're just looking for a delta from the previous day? I would recommend using a measure for this. 

[Pquinlan21]

Yes, I am trying to determine the delta for each day.

[CoreyP]

Sample Data:

Model:

Result:

Measures:

Day Total = SUM( Data[Value] )

Previous Day Total = CALCULATE( [Day Total] , PREVIOUSDAY( 'Date'[Date] ) )

Delta Previous Day = Data[Day Total] - [Previous Day Total]