Sorting Date

[tvisha]

Hi,

I need to get the top 4 or the max 4 dates. I am using the below in the expression in the chart,

=if(year(date([Week Ending]))=year(date(Today())),
if(week(date(Today()))-week(date([Week Ending]))<5,(weekstart([Week Ending])))
)

However it is giving me as, I am not understanding why I am getting those - , I just need the top 5. Sample data attached. 

Thank You,

[vinieme12 · Accepted solution]

You just need to uncheck >> include Null Values for this dimension

Also try below expression

=Aggr(if([Week Ending]>=Max([Week Ending],5),Weekstart([Week Ending])),[Week Ending])

[tvisha]

Thank you that worked. I thought that, but as the data did not had any null values in the original excel I was not sure. Not sure how null is introduced here.