Hello!
I have the following matrix with the following data to display:
-As it is visualized, week 1 appears with dates 02-01, 03-01, 04-01. All these dates belong to week 1 but of the year 2023. The problem is that I want this "Week 1" of the year 2023 to be positioned at the end of the weeks.
What I try to do:
My calendar table is made as follows:
| Date | Claim | IdMes | IdTtrimestre | IdSemestre | IdAño | IdSemana | DescDia | DescSemana | DescMes | DescMesCorta | DescSemestre | DescSemestreCorta | Year | Season | Week | Order Season | Order of the week | Name day week | Today | Comb(Temp,Week) | Dia-MesMes | my | Agenda-Month | Conditional week | Conditional current week |
| 08-01-2023 | 20230108 | 202301 | 20231 | 20231 | 2023 | 202302 | Sunday, January 8, 2023 | 2023 Week 02 | Sunday, January 1, 2023 | January | 2023 Semester I | Semester I | 2023 | R7 | 1 | 41 | Sunday | 04-01-2023 | R71 | 08-01 | 1 | 4 | NO | YES | |
| 07-01-2023 | 20230107 | 202301 | 20231 | 20231 | 2023 | 202301 | Saturday, January 7, 2023 | 2023 Week 01 | Sunday, January 1, 2023 | January | 2023 Semester I | Semester I | 2023 | R7 | 1 | 41 | Saturday | 04-01-2023 | R71 | 07-01 | 1 | 4 | NO | YES | |
| 06-01-2023 | 20230106 | 202301 | 20231 | 20231 | 2023 | 202301 | Friday, January 6, 2023 | 2023 Week 01 | Sunday, January 1, 2023 | January | 2023 Semester I | Semester I | 2023 | R7 | 1 | 41 | Friday | 04-01-2023 | R71 | 06-01 | 1 | 4 | NO | YES | |
| 05-01-2023 | 20230105 | 202301 | 20231 | 20231 | 2023 | 202301 | Thursday, January 5, 2023 | 2023 Week 01 | Sunday, January 1, 2023 | January | 2023 Semester I | Semester I | 2023 | R7 | 1 | 41 | Thursday | 04-01-2023 | R71 | 05-01 | 1 | 4 | NO | YES | |
| 04-01-2023 | 20230104 | 202301 | 20231 | 20231 | 2023 | 202301 | Wednesday, January 4, 2023 | 2023 Week 01 | Sunday, January 1, 2023 | January | 2023 Semester I | Semester I | 2023 | R7 | 1 | 41 | Wednesday | 04-01-2023 | R71 | 04-01 | 1 | 4 | YES | YES | |
| 03-01-2023 | 20230103 | 202301 | 20231 | 20231 | 2023 | 202301 | Tuesday, January 3, 2023 | 2023 Week 01 | Sunday, January 1, 2023 | January | 2023 Semester I | Semester I | 2023 | R7 | 1 | 41 | Tuesday | 04-01-2023 | R71 | 03-01 | 1 | 4 | YES | YES | |
| 02-01-2023 | 20230102 | 202301 | 20231 | 20231 | 2023 | 202301 | Monday, January 2, 2023 | 2023 Week 01 | Sunday, January 1, 2023 | January | 2023 Semester I | Semester I | 2023 | R7 | 1 | 41 | Monday | 04-01-2023 | R71 | 02-01 | 1 | 4 | YES | YES | |
Very grateful in advance
1 ACCEPTED SOLUTION
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
