Include missing week numbers in pivot from powerquery if no data is available

Hi Community,

I have a powerQuery getting information from an external Database with Dates.
I'm converting the dates into week numbers and using these as columns in my Pivot.
Sometimes there will be no data for a given week, when that is the case, that week number will be missing.

I need a way of including the week number and populating with zeros if there is no date available for that week.

See attached for example.
'Table3' has the pivot from the PowerQuery I have constructed from data on 'Sheet3'
I have labelled as what I get, and created another beneath labelled a what I want.

Hope I have explained clearly.

I like it!
Haven't figured it out exactly how it works, but I can definitely copy the example and incorporate as needed.
Thanks.