Forum Discussion
Creating a YTD Daily Average Measure
You want to use the Day of Year calculation from this answer: https://community.powerbi.com/t5/Desktop/Day-number-of-year-DAX/m-p/338657/highlight/true
Then sum your Monthly Avg. Impressions and divide it by the Day of Year calculated result.
You want to use the Day of Year calculation from this answer: https://community.powerbi.com/t5/Desktop/Day-number-of-year-DAX/m-p/338657/highlight/true
Then sum your Monthly Avg. Impressions and divide it by the Day of Year calculated result.
Thanks! This was the missing piece I believe.
Would you know how to modify the Day of Year calculation to account for a Fiscal Year (e.g., Jul - Jun)?
Hmm, good question. I think you might want to use the DATESBETWEEN function instead: https://docs.microsoft.com/en-us/dax/datesbetween-function-dax Then specify the start date as your start of fiscal year.
Try something like this:
Day of the Fiscal Year = COUNTROWS(DATESBETWEEN('Dates'[Date].[Date],DATE(2021,7,1),TODAY()))