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
Scenario 1: When year slicer filtered for 2011 ( march,april,may) the total would be 92 (31 + 30+31).
|Month||Days in Month|
Can any one help me on urgent bases.
All help will be appreciated.
Thank you so much
Solved! Go to Solution.