Tabla Calendario en DAX - Power BI

This article provides a DAX script for creating a reusable calendar table in Power BI. The script generates common time-intelligence columns such as Year, Month, Quarter, and Week, using the `CALENDAR` and `ADDCOLUMNS` functions. Users are instructed to paste the code into Power BI's "New Table" option and adjust the table and date column references to match their own data.

gistfile1.txt This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters Show hidden characters // -------------------------------------------------------------------------- / Tabla Calendario en DAX - Power BI Crear una tabla de dimensión temporal reutilizable en DAX. El script genera columnas de tiempo: Año, Mes, Día, Trimestre, Semana, Semestre, Período YYYYMM , Inicio/Fin de Mes, y más. Uso: 1. Power BI → Vista de Modelo → Nueva tabla 2. Pega el código 3. Cambia fact sales denormalized y sales date por tu tabla/columna. Dale enter. 4. Relaciona los campos de fecha Siéntete libre de adaptarlo. Si tienes sugerencias, avísame. / // -------------------------------------------------------------------------- Calendario = ADDCOLUMNS CALENDAR MIN fact sales denormalized sales date , MAX fact sales denormalized sales date , "Año", YEAR Date , "Número Mes", MONTH Date , "Mes", FORMAT Date , "MMMM" , "Mes Corto", FORMAT Date , "MMM" , "Día", DAY Date , "Día de la Semana", FORMAT Date , "dddd" , "Día de la Semana Corto", FORMAT Date , "ddd" , "Número Día Semana", WEEKDAY Date , 2 , "Periodo", YEAR Date 100 + MONTH Date , "Inicio Mes", DATE YEAR Date , MONTH Date , 1 , "Fin Mes", EOMONTH Date , 0 , "Trimestre", "Q" & FORMAT Date , "Q" , "Semana del Año", WEEKNUM Date , 2 , "Semestre", IF MONTH Date <= 6, 1, 2