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.
Hi Community,
I am new to power BI, and facing a problem when calculatinig total days in year for each month.
I could achieve getting the number of days per month by using NumberDaysMonth = DAY(ENDOFMONTH('Calendar'[Date])) however, I need their sum when we filtered with year
for example:
Scenario 1: When year slicer filtered for 2011 ( march,april,may) the total would be 92 (31 + 30+31).
Month | Days in Month |
October | 30 |
December | 31 |
September | 30 |
November | 31 |
122 |
Can any one help me on urgent bases.
All help will be appreciated.
Thank you so much
Solved! Go to Solution.
@Anonymous,
You may try a similar way as shown here.
@Anonymous,
You may try a similar way as shown here.
@Anonymous
What do you get if you use a MEASURE like
Measure = Count('Calendar'[Date])
Thanks For your reply,
Below is the output i am getting.
Month | Days in Month |
October | 22 |
December | 22 |
September | 22 |
November | 22 |
88 |
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |