How to get rolling day sales with change in dates

[Sajid02]

Hi Folks , 

Pls help me in getting the solution to get the difference of amout with change in dates .

Snip of data :-

Need data like :-

So , as per snip it is clearly visible like with the change in dates , there is only difference amount is showing to next date. It needs to show the movement between each day.

Criteria :

The first date will be full balance (B34-B47 in attachment) – but then every other date should show movement between dates (see C34-C47 in attachment)

kindly help me in getting this solved .

[Sajid02]

@amitchandak 

Any solution around this

[amitchandak]

@Sajid02 , Based on what I got, this day vs previous day solution should work

Assume you have measure already

example

This Day = [measure]

This Day = CALCULATE([measure], FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE([measure], FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE([measure], previousday('Date'[Date]))

diff =[This Day] - [Last Day]

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

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

[Sajid02 · Accepted solution]

Last Day = CALCULATE([measure], previousday('Date'[Date]))

diff =[This Day] - [Last Day]

This step is working.

Many Thanks