Calculate weekly moving average since start dec 2019

[ItAnthonyWright]

I am looking to created a weekly moving average based off of the number of tickets logged in regards to the category it was logged under.

I am using the TicketID's which are like 23451, 26513 etc, so the average from that just doesn't work and I can't seem to count the average of them either.

Any help would be appriciated!

[Anonymous]

Hi @ItAnthonyWright ,

Please show some sample data and expected result so that we could test DAX formula for you.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

Best Regards,

Jay

[ItAnthonyWright]

Hi Jay,

Please see the below screenshots of the raw data and the expected outcome.

Raw Data - Need the average count of TicketID for the specific category weekly.

Expected - This is the excel worksheet that I am trying to recreate. I have the table but I cannot get the weekly average and difference to the previous week. 

Thanks,

Anthony