Find Customer name who ordered on Latest Month -end date available.

[Anonymous]

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)

[Anonymous · Accepted solution]

Dimension: if(BusinessDate = '$(=date(max(monthend(BusinessDate))))'),date(Monthend(BusinessDate),'MMM-YY')