My company has mid month reports and I'm having trouble getting my calendar days per monthly reporting period. For example, If I pull the January report; MONTH PERIODJANUARY 16 NOV - 15 DECFEBRUARY 16 DEC - 15 JAN I want to use a Splicer with MONTH and Pick my Reporting Period.

hi TimsLanding try to add a column in your calendar table like:Column =IF( DAY([Date])>=16, FORMAT(EOMONTH([Date], 2) ,"mmmm"), FORMAT(EOMONTH([Date], 1) ,"mmmm"))