Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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])"}
Dollar sign expansion is taking 30/11/2016 as a division rather than a date.
How do I bring back a date ? do I have to use Makedate from Max over year,month and day?
Why can't you just use this?
=Date(Max({$}[Master Month Date]),'DD/MM/YYYY')
Where exactly are you using this?
I am using inside set analysis
[MonthLogged_Open_Balance]={Date(Max({$}[Master Month Date]),'DD/MM/YYYY')}
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])"}