Calculating difference between columns

[hhdez]

Hi,

I have the following table multiple sales forecasts for future months:

                     July (month we are forecasting)                         

                    May 1    May 8    May 15   May 22   May 29   (each one of the dates in which we generated a forecast)    

Product A      10          12            11          13           10            

What I would like to do is calculate the delta between each one of the snapshots. Something like this

                    July (Forecast)                                                          July (Deltas)

                    May 1    May 8    May 15   May 22   May 29           May1-8     May8-15     May15-22    May 22-29

Product A      10          12            11          13           10                     2               -1                  2                  -3

I already looked at several solutions and I am not quite there.

I would really appreciate any help!!

[amitchandak · Accepted solution]

@hhdez ,Last Day Non Continuous day or tailing 7 should work in case you have date

example

Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))

or

Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =calculate( max(Sales[Sales Date]), FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])))))

7 Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,Day))

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[hhdez]

This worked! Tks