Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |