title: How to get Last Selling Price in MDX
body: <p>Can MDX return the Expected Result as per code below? 
  Have the data as per below :</p>
  
  <pre><code>DATA:       
  ItemID  DateKey Price
  A   20151230    4.85
  A   20150520    5.5
  A   20150325    4.65
  B   20140130    3
  B   20141130    5
  B   20150630    4.5
  
  Wrong Result:
  ItemID  DateKey Price
  A   20151230    4.65
  B   20150630    3
  
  Expected Result:
  ItemID  DateKey Price
  A   20151230    4.85
  B   20150630    4.5
  
  WITH MEMBER [LastDate] AS tail (Filter([BI Dim Date].[Date Key].[Date Key],[Measures].[PRICE])).Item(0).name
  MEMBER [LastDateWithSales] AS Filter([MyTest].[PRICE].[PRICE],[Measures].[LastDate]).Item(0).name
  
  SELECT { [LastDate], [LastDateWithSales]} ON columns,
  [MyTest].[ITEMID].[ITEMID] on rows
  FROM [MyCube]
  </code></pre>
  
  <p>Execute the above MDX but get wrong result. Please advise.</p>