Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
hi @TimsLanding
try to add a column in your calendar table like:
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.
hi @TimsLanding
try to add a column in your calendar table like:
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.