Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.