DAX Using a Measure in formula produces a blank and can't see why

[Dicken]

I have cross posted this question with MR. Excel ;

Please Login or Register  to view this content.

Hi, i have the following measure formula in DAX power pivot to retrieve the previous unit value, I have attached the workbook with examples of each.

so first to get the previous date ;

Please Login or Register  to view this content.

Then ;

Please Login or Register  to view this content.

So I thought I should be able to use the first measure inside the second,

Please Login or Register  to view this content.

But this just return a blank? Any explanations as to why?