Help with DAX function

[Anonymous]

Dear,

I'm making a power BI set where i upload every half hour new information via excel. In essence it's a view of the current/open orders.

Green = picked orders

Red = open orders 

Blue = forecast

Now i would like to add a line which shows the new orders, it's basically the open + picked orders form the lastest meassurement - open + picked orders from the previous meassurement. Does anyone know how to do this?

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[Anonymous]

Hi @amitchandak 

Hopefully i can explain better with an example, please see the graph attached.

at 09:00 there were 92 open orders and 64 picked orders = 92 + 64 = 158 total orders
at 09:30 there were 94 open orders and 122 picked orders = 94 + 122 = 216 total orders

This means that in this half hour there were 216 - 158 = 58 new orders generated. 

Now i'm looking for a DAX formula that can do this calculated for me automatically for every interval.