This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
I operate a PBI report for our work Fantasy Football league, over the season it has given me the opportunity to learn more about Power BI based upon requests from participants in the league. We have various attributes for each participant so we can display data by site and department and our Headline page shows data as below. One request has me stumped. I want to be able to combine scores achieved in several weeks to show the score for a month.
My data is arranged so that for each player for each matchday we have the points that they have scored, the contest spans over 9 months with there being a total of 38 matchdays, I have a table of data that identifes in which month each matchday occurs. The example shown here shows values over the months but it is only the first scoring week for each month - what is the best way to use data transformation so that values from W1-W36 map to Months 1-9?
@Anonymous
How are you planning to aggregate weeks into months?
Because weeks can fall to 2 different months
The weeks are tagged as being associated with a specific month, the data is not date driven, the columns in the Excel are text values that denote Matchday (Week Number) and in which Month the Matchday occured.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 36 | |
| 33 | |
| 31 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 66 | |
| 55 | |
| 31 | |
| 24 | |
| 23 |