Forum Discussion
Daily Average Over Multiple Years
Hello,
Sorry again for the delay. Unfortunately these solutions did not work for what I wanted so I ended up doing it the way that would lose the metadata but kept the main numbers. So I ended up making a seperate query for each year grouped by the main categories we want, merging the queries together, then adding average columns. Not ideal but it worked. I'll just have to make separate visuals for the metadata.
Thank-you,
Tanya
To calculate and display the daily average across multiple years in Power BI, you need a measure that aggregates the data correctly and then divides by the number of years. Here's a simple approach:
Steps to Calculate Daily Average Across Years:
Create a measure that sums the total count for each day across all available years.
Count distinct years in your data.
Divide the total daily count by the number of years to get the average.