Number of Days in YTD through End of Last Monday

[TravisGlanzer]

I am trying to get an quantity per day average in Power BI.  I used the following formula to calulate the number of days in each month:  

Number of days in month = DATEDIFF( EOMONTH(max('DateTable'[FiscalDate]),-1),EOMONTH(max('DateTable'[FiscalDate]), 0), DAY)

The per month YTD Total Average is correct but the formula is only giving me 31 days for the total when I need it to report 90 day total when selecting these three months

[jthomson · Accepted solution]

Change the first max to min and it should work?