Forum Discussion

tl1234's avatar
tl1234
Helper I
9 months ago
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...
Need Help
  • tl1234's avatar
    tl1234
    8 months ago

    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

Praful_Potphode's avatar
Praful_Potphode
Super User
9 months ago

Hi tl1234 ,

 

did you try creating column(as shown in your image) and plotted the column in line chart?

the formula for new column may look like below:

Average = DIVIDE(YourTable[2023]+YourTable[2024],2)

 

the visualization may look like below.

The axis is not sorted.but you can sort it as per your requirements.also you can change line style to dotted/dashed/custom as per your requirements.

 

Please give kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful