Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |