Forum Discussion
Solved
Daily Average Over Multiple Years
Hello, I've made the below visual which represents the total number people staying at our facility every day split up by year. What I need is a daily average across years (shown in red text in im...
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
Hi,
Share some data to work with. Share it in a format that can be pasted in an MS Excel file. You may also share the download link of the PBI file.