Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

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's avatar
    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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

This should get your desired result in a calculated column (this example is on the Date table).

 

Month Complete = IF(EOMONTH('Date'[Date],0)<=TODAY(), "Yes", "No")
 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

JezzatheGee's avatar
JezzatheGee
Icon for Advocate II rankAdvocate II
2 years ago

Perfect - very simple but does the job!!