This content has been marked as final.
Show 4 replies
-
Re: Max Date as Dimension
Digvijay Singh Mar 27, 2018 1:56 PM (in response to Stewart Sims)May be try this -
if(Date=Max(Date),Date)
or
Aggr(if(Date=Max(Date),Date),Date)
or
Aggr(Only({<Date={$(=Max(Date)}>}Date)
-
Re: Max Date as Dimension
Stewart Sims Mar 27, 2018 2:11 PM (in response to Digvijay Singh )Thank you for the ideas... I was hopefull that adding the if statement would work, but unfortunately not.
if(Date=Max(Date),Date) returned invalid dimension error
Aggr(if(Date=Max(Date),Date),Date) returned the Date and not max date
Aggr(Only({<Date={$(=Max(Date)}>}Date) returned invalid dimension error
-
Re: Max Date as Dimension
Stewart Sims Mar 27, 2018 2:24 PM (in response to Stewart Sims)Your ideas helped and I got it to work by adding TOTAL to Max and wrapping it with AGGR.
Date(Aggr(Max(TOTAL Date),Date),'YYYY-MM-DD')
-
-
-
Re: Max Date as Dimension
omar bensalem Mar 27, 2018 2:24 PM (in response to Stewart Sims)=aggr(max(all Date),Date)