Calendar Table with Mid Month Reporting Periods

[TimsLanding]

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             PERIOD

JANUARY           16 NOV - 15 DEC

FEBRUARY         16 DEC - 15 JAN

I want to use a Splicer with MONTH and Pick my Reporting Period. 

[TimsLanding]

Yes sir! That definitely worked! I have no idea how that formula works, just by having it Greater than or equal to 16, it knows that's the day count of the month, I love it. 

[FreemanZ · Accepted solution]

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")

)

[TimsLanding]

If I wanted to count the days of the reporting period, do you know the DAX formula for that? Each time I try CALCULATE(COUNTROWS(DateTable),'DateTable[ReportPeriod]) it states that "July" must be a true or false statement.