title: Can't get CUBEVALUE to filter by date value in cell
body: <p>My data model has a column named <strong>rowDate</strong>. This column has several repeating instances of dates due to the fact that there are multiple rows of data for different times of a single day.</p>
  
  <p>I've written a measure that sums the values in another column from the data model that I want to pull from. (We'll call this <strong>MyMeasure</strong>.)</p>
  
  <p>I'm trying to write a CUBEVALUE formula that extracts the total of <strong>MyMeasure</strong> when <strong>rowDate</strong> equals the value of a cell in a worksheet. (This will allow the result of the CUBEVALUE to change based on the date that the user inputs into cell B2.)</p>
  
  <p>e.g.</p>
  
  <p>Cell B2 = "2018-06-29" (date formatted)</p>
  
  <pre><code>=CUBEVALUE("ThisWorkbookDataModel","[MyMeasure]","[Summary Data].[rowDate].["&amp;$B$2&amp;"]")
  </code></pre>
  
  <p>This always returns #N/A. I have another column with data (a number) that I can write the exact same CUBEVALUE formula, but referencing the appropriate cell, and it works just fine. It's just this date column that I can't figure out.</p>