Forum Discussion
Solved
Creating a YTD Daily Average Measure
Hello! I am having a tough time wrapping my head around the steps necessary to create a DAX measure to capture YTD daily averages with the information below: Because each month contains...
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)?