SSAS Date Measure Max StringFormat when Null

I have a cube with a measure of type 开发者_如何学Godate, performing a max aggregation, where some of the data points have a null value for date. In these cases, the Max value becomes 12/30/1899 which I believe is the earliest expression of a date.

Is there a way to have these appear in the results as blank rather than this bogus date?

I tried to use the measure's StringFormat property with no luck.

Change the NullProcessing property for your measure to Preserve. You can do this in BIDS. Open the project, then the cube, then on the Cube Structure tab expand the measure group and then select the measure. In the properties pane select Source, expand it and you should see the property there. After you process, the measure will be NULL instead of the default 0 which gets assigned to NULLs. The 0 then gets cast to a date and becomes 00/01/1900 in Excel.