Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have created a variable: with the date field
vMonthEnd = date(monthend(max(dates),-1))
but =if(dates=$(='vMonthEnddd'),dates) is not working in filter pane.
May be try this
If(dates = Floor($(vMonthEnd)), dates)
or this
If(dates = Floor(MonthEnd(Max(TOTAL dates), -1)), dates)
No, it is showing NULL.
May be try this
If(dates = Floor($(vMonthEnd)), dates)
or this
If(dates = Floor(MonthEnd(Max(TOTAL dates), -1)), dates)
In the UI for pivot table