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:
-
Power BI → Vista de Modelo → Nueva tabla
-
Pega el código
-
Cambia fact_sales_denormalized y sales_date por tu tabla/columna. Dale enter.
-
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)
)
source & further reading
gist.github.com — original article
A battle-tested AGENTS.md for higher quality code output. Helps avoid "AI slop creep" by keeping your codebase lean and clean.
A New Gist from my side
Run Claude's most powerful model at half the price, Anthropic's two official patterns + the exact setup