Matrix

[Syndicate_Admin]

Hello everyone, they ask me for a complicated report but I have not managed to put it together I detail the requested report.

1. Sellers

2. Sales data per week between the years 2021 and 2022

3. Make an accumulated from week 1 to 48 of the year 2021

4. Show individual week 49 to 53 of the year 2021

5. In the same report show the weeks by individual of the year 2022

6. Obtain metrics of sales increase per seller by comparing last weeks and previous week of the year 2022.

I show you how far I have come and you can get the subsection 1 to 4 but when I want to place it the weeks of the year 2022 these are also placed in the year 2021.

I attach an image of how the report is shown, in steps 1 to 4

When I want to add step 5 that are the weeks of the year 2022 from week 1 what the matrix does is that it adds week 1 in the year 2021 and that week I do not want it to be shown in that year and adds the columns that are in the year 2021 in the year 2022 attached image of the report.

and what they ask me is that it be shown in this way this is an excel.

I have even created measures that are filtered by the year but always add the column in 2021, an example of a measure that uses

Week 1 for 2022 = CALCULATE([Week 1], 'Calendar'[Year] IN { 2022 })

I would greatly appreciate your help with this report it can not be that I am complicated life and is a solution easier than I think.

As a comment, I don't have much time working with Power BI.

Thanking you for your help and your time

Best regards

[lbendlin]

Create a YearWeek column and then create groups based on your requirements.

Or use a SWITCH statement to define the aggregation level for each Year and week.

Please provide sanitized sample data that fully covers your issue.