Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
@Anonymous
You'll need to create relationship on [month] column.
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.
User | Count |
---|---|
89 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |