Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hola equipo,
¿Alguien puede compartir un archivo PBIX que muestre un calendario semanal que comienza un jueves de 2022 a 2024?
También quiero poder filtrar los datos con una segmentación semanal para el período 2022 - 2024
Gracias de antemano
11-30 | 12-7 | 12-14 | 12-21 | 12-28 | 1-4 | 1-11 | 1-18 | 1-25 | 2-1 | 2-8 | 2-15 | 2-22 |
Solved! Go to Solution.
Hola @HarryB
La siguiente fórmula es un ejemplo de tabla de calendario DAX. Esta es una tabla calculada.
Calendar =
VAR __MIN =
DATE ( 2022, 1, 1 )
VAR __MAX =
DATE ( 2024, 12, 31 )
VAR __BASE =
CALENDAR ( __MIN, __MAX )
VAR __RESULT =
ADDCOLUMNS (
ADDCOLUMNS (
__BASE,
"Year", YEAR ( [Date] ),
"Month Long", FORMAT ( [Date], "mmmm" ),
"Month Short", FORMAT ( [Date], "mmm" ),
"Month Number", MONTH ( [Date] ),
"Month and Year", FORMAT ( [Date], "mmm-yy" ),
"YYYYMM", FORMAT ( [Date], "YYYYMM" ),
"Quarter", "Q" & QUARTER ( [Date] ),
"Day of Week Long", FORMAT ( [Date], "dddd" ),
"Day of Week Short", FORMAT ( [Date], "ddd" ),
"Day Sort", WEEKDAY ( [Date], 1 ),
"Week of Year", WEEKNUM ( [Date] ),
"Week Ending Saturday",
VAR __DAY =
WEEKDAY ( [Date] ) - 7
RETURN
[Date] - __DAY,
"Week Ending Wednesday",
VAR __DAY =
WEEKDAY ( [Date] ) - 4
RETURN
[Date] - __DAY
),
"Week Starting Thursday", [Week Ending Wednesday] - 6
)
RETURN
__RESULT
Bienvenido. Por favor, acepte mi respuesta como solución.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |