Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@Syndicate_Admin , Add year also has one the field in column
@Syndicate_Admin , Add year also has one the field in column