Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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])
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])
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.