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;
JANUARY 16 NOV - 15 DEC
FEBRUARY 16 DEC - 15 JAN
I want to use a Splicer with MONTH and Pick my Reporting Period.
Go to Solution.
try to add a column in your calendar table like:
View solution in original post
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.
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.
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!