You can find the latest price with the row_number window function:

WITH tmp AS
(
    SELECT 
        pt.ItemNbr,
 ...

I was not able to carry out the instructions as written. There was no way to specify a Name column. I created the named calculation as suggested but it took...

False alarm. I selected the wrong project. All is well. Thanks again to Jesus (De los Santos Rodriguez-360037, that is).

Unfortunately, with that project I get this error while processing:

OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimTime'.; 42S02.

My DW2008R2 database has no DimTime but there is...

It eventually took 5 hours and 6 minutes. I found the project in a folder sourceCode\sourceCode.zip\Kilimanjaro_RTM\AdventureWorks 2008R2 Analysis Services Project.

It is late now so I will try it tomorrow.

Thanks, Jesus. Your searching skills are better than mine. How did you find it?

Anyway, I am downloading it now. It is going to take about another 3 hours. Apparently the...

Thanks, Jesus, but that link does not have what I need. That link points directly to various 2008R2 databases. At the top it has this link:

For multidimensional and tabular models,...