Hi folks,

I wonder if someone did a project where he/she needed to construct a model that checks how the company performed Vs the forecast? 

How should I construct the model? Should it be 2 files (actual, forecast) or is there another way?

In addition to that, I have data of prices that will update throughout time + I have the quantities I need to order. 

I can order quantities on any day, and the price I will use will be the last known... 

So if the price list update was in 12/6/2014 and reservation has been made in the 15/6/2014 then I will use those prices, whereas if the purchase to be made in 10/6/14 I will use the previous price list. 

To clarify- please find attached:

Does anyone know how to create the appropriate DAX formula?

Thanks