By storing the max value in the variable you can also sum the
Source:
LOAD Date(Date,'M/D/YYYY') AS Date, Date(LoginDate,'M/D/YYYY') AS LoginDate,Sales;
LOAD * INLINE [
Date, Sales, LoginDate
1/1/2014, 3343, 1/1/2014
1/2/2014, 454, 1/1/2014
1/3/2014, 65, 1/2/2011
1/4/2014, 64767, 1/3/2014
1/5/2014, 7676, 2/1/2012
1/6/2014, 7767, 1/10/2014
1/7/2014, 7676, 1/1/2012
1/8/2014, 7676, 1/10/2014
1/9/2014, 767, 1/1/2014
1/10/2014, 767, 1/1/2014];
MaxTable:
LOAD
Date(Max(LoginDate))as MaxDate
Resident Source;
LET vMax = Peek('MaxDate',0,'MaxTable');
And in front end
Dimension:- Date
Expression:- Sum({<Date ={'$(=vMax)'}>} Sales)
But check the date formats of the fields but i suggest use variables for finding the max dates by storing the max date in the variable and then use it on the expression.
