I have built everything according to the instructions provided but for some odd reason it either calculates by 4 weeks when I use MIN or 5 weeks when I use MAX. I need for the my visual to show the average weekly spend for each month and it must be calculated by each month's corresponding number of Thursdays.
So, I have created the relationship between the tables. However, it seems the thurs table is limited to a single year. I had to create multiple tables for each year of data but I wasn't able to use a single table for the rolling 12 month matrix. I am working on possibly using an if statement to ensure that the calculation uses the 2018 thurs table for the 2018 months.