Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |