Forum Discussion
Calendar Table with Mid Month Reporting Periods
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.
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"))
3 Replies
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"))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.
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.
