Why is their a different result in $ Expansion over a formula

[tinkerz1]

Hi,

Why do I get a different result in a text box when I use dollar expansion over a normal formula

=$(=DATE(Max({$}[Master Month Date]),'DD/MM/YYYY'))  Result 0.001335

=DATE(Max({$}[Master Month Date]),'DD/MM/YYYY') Result 30/11/2016

Why does the expansion produce a number?

[sunny_talwar]

Dollar sign expansion is taking 30/11/2016 as a division rather than a date.

[tinkerz1]

How do I bring back a  date ? do I have to use Makedate from Max over year,month and day?

[sunny_talwar]

Why can't you just use this?

=Date(Max({$}[Master Month Date]),'DD/MM/YYYY')

Where exactly are you using this?

[tinkerz1]

I am using inside set analysis

[MonthLogged_Open_Balance]={Date(Max({$}[Master Month Date]),'DD/MM/YYYY')}

[sunny_talwar · Accepted solution]

So this isn't working?

[MonthLogged_Open_Balance]={"$(=Date(Max({$}[Master Month Date]),'DD/MM/YYYY'))"}

or this may be:

[MonthLogged_Open_Balance]={"=[MonthLogged_Open_Balance] = Max(TOTAL [Master Month Date])"}