Weekly Moving Average appointments count

[Anonymous]

Hi,

I have been banging my head on this one a while, I need a Graph that displays the weekly moving average (X = Count of meetings / Y = Weeknumber) the last 6 months.

As of now i have a dataset imported from Excel with all the appointement data, each participant is a row in the dataset so there can be several rows for each appointment.

Anyone got any tip on how to think on this one, i fear i miss some fundamental stuff, i have tried the solutions from serveral "moving average" threads in the community but with no help.

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may view the code generated by Quick measure Rolling average.

https://community.powerbi.com/t5/Desktop/I-want-to-get-an-average-of-three-months-from-next-month-to/m-p/634808#M303627

[Anonymous]

Hi,
Thanks for the tip, I will check that out directly!