Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save raycalvodev/2d532d264010fc085379159b579e4b8e to your computer and use it in GitHub Desktop.
Save raycalvodev/2d532d264010fc085379159b579e4b8e to your computer and use it in GitHub Desktop.
Código DAX para crear una tabla de calendario personalizada en Power BI
VAR YearFechaMax = YEAR(MAX(fctVentas[Fecha Orden]))
VAR CalendarioInicial =
FILTER(
CALENDARAUTO(),
YEAR([Date]) >= YearFechaMin &&
YEAR([Date]) <= YearFechaMax
)
VAR Calendario =
SELECTCOLUMNS (
CalendarioInicial,
"Fecha",[Date],
"Año", YEAR ( [Date] ),
"Mes", FORMAT ( [Date],"MMMM"),
"Periodo", INT(FORMAT([Date], "YYYYMM")),
"Mes-Año", COMBINEVALUES("-", FORMAT ( [Date],"MMM"), YEAR ( [Date] )),
"MesNro",INT ( FORMAT ( [Date],"M" ) ),
"NroDia",INT ( FORMAT ( [Date],"d" ) ),
"Trimestre", "T" & ROUNDUP ( MONTH ( [Date] ) / 3,0 ),
"NroTrimestre",ROUNDUP ( MONTH ( [Date] ) / 3,0 ),
"DiaSemana",WEEKDAY ( [Date],2 ),
"Semana", WEEKNUM ( [Date],2),
"Nombre Dia", FORMAT ( [Date],"DDDD"),
"Año-Trimestre", COMBINEVALUES ("-",YEAR ( [Date] ), "T" & ROUNDUP ( MONTH ( [Date] ) / 3,0 )),
"MesCorto", FORMAT ( [Date],"MMM" ),
"Dia",DAY([Date]),
"Mes Actual",MONTH ( TODAY () ),
"Trimestre Actual",ROUNDUP ( MONTH ( TODAY () ) / 3,0 ),
"Semestre", ROUNDUP ( INT ( FORMAT ( [Date],"M" ) ) * 2 / 12,0 ),
"Año-Mes",COMBINEVALUES ( "-",YEAR ( [Date] ),FORMAT ( [Date],"MM" ) ),
"IdFecha", YEAR ( [Date] ) * 10000 + MONTH ( [Date] ) * 100 + DAY ([Date])
)
RETURN Calendario
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment