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
Go to Solution.
Change the first max to min and it should work?
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.