Connecting Week on Week Data to Calendar fact Table

jhauw74 , Assume you do not have data at date level
You can create date based on date part you have in the date

 

Date = datevalue(right([Week COlumn],10))

 

Then you can join if with calendar table having week and create WOW measures

 

Calendar
Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e6f593958

 

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510

Hi jhauw74 

You can add a column with an extracted date and relate the table to the calendar table by this new column.

To get an extracted date easily  you can use an option "column from example" "

Pbix is attached you can follow my steps

More information about the column from  example here:

https://www.youtube.com/watch?v=UG26NKSNqoc

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly