Follow up: Average weekly spend for each month by number of week

[Anonymous]

Hi @TeigeGao, 

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. 

Please help.

Previous Post: https://community.powerbi.com/t5/Desktop/Average-weekly-spend-for-each-month-by-number-of-week/m-p/7... 

Thanks!

mel 

[v-chuncz-msft]

@Anonymous 

You'll need to create relationship on [month] column.

[Anonymous]

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.