Filter just for completed months

Hello everybody! I need to add a column to my calendar to filter in my views just for completed months. The calendar I am using is a fiscal calendar like Date - Fiscal Month Does someone know ...

Need Help

Anonymous

6 years ago

// Let's say that FiscalMonthID is
// a unique identifier of a fiscal
// month in Calendar.

[Full Fiscal Month] = // calculated column
var __today = TODAY()
var __currentFiscalMonth = Calendar[FiscalMonthID]
var __allFiscalMonthDatesAreOK =
	ISEMPTY(
		FILTER(
			'Calendar',
			Calendar[FiscalMonthID] = __currentFiscalMonth
			&&
			Calendar[Date] > __today
		)
	)
RETURN
	__allFiscalMonthDatesAreOK

Best
D

Forum Discussion

Filter just for completed months