Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to find data for all the customers who made an order on latest month -end date. For Example, today is 15 -oct so Fetch data for 30-sep.
Step I tried,
$(vLatestMonthEnd) : date(max({$<IsMonthEnd={1}>}BusinessDate),'MM/DD/YYYY')
But when I am trying to fetch data for above date it is giving me invalid dimension.
Dimension: if(date='$(vLatestMonthEnd)',CustomerName)
Dimension: if(BusinessDate = '$(=date(max(monthend(BusinessDate))))'),date(Monthend(BusinessDate),'MMM-YY')
Dimension: if(BusinessDate = '$(=date(max(monthend(BusinessDate))))'),date(Monthend(BusinessDate),'MMM-YY')