cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrangelWG Frequent Visitor
Frequent Visitor

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

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 

2 REPLIES 2
Community Support Team
Community Support Team

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

@mrangelWG 

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mrangelWG Frequent Visitor
Frequent Visitor

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

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. 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors