Fact Vs Forecast

[AmitM]

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

 

[scottsen]

Your model does look rather atypical. Normally when you buy something, you know how much you spent and who you bought it from... all in 1 table

Yes, a measure can return text.

 

[AmitM]

Thx A lot.

one Q about the measure- if it returns text, that won't help me to display it, right? as the measure only visible in Pivots, and those display only # (?)

 

[scottsen]

Measure in PowerPivot can return text that is displayed in the values portion of a pivot table. I swear!