Para criar a DCalendario no Dax, clique em Ferramentas da Tabela, Nova Tabela e insira o código abaixo:
Date =
ADDCOLUMNS (
CALENDAR (DATE(2018,1,1), DATE(2025,12,31)),
"DataReferencia", FORMAT ( [Date], "DD/MM/YYYY" ),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Ano", YEAR ( [Date] ),
"AnoCurto", FORMAT ( [Date], "YY" ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"YearMonthnumber", FORMAT ( [Date], "YYYY.MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY.mmm" ),
"YearMonthDayShort", FORMAT ( [Date], "YYYY.mmm.DD" ),
"AnoMesDia", FORMAT ( [Date], "YYYY.mm.DD" ),
"DiaMesExtAno", FORMAT ( [Date], "DD.mmm.YYYY" ),
"MesExtAno", FORMAT ( [Date], "mmm.YYYY"),
"MesAno", FORMAT ( [Date], "mm.YYYY" ),
"MesAnoFN", FORMAT ( [Date], "mmm" ) & "." & FORMAT ( [Date], "YY" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"Dia", FORMAT ( [Date], "DD" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Trimestre", FORMAT ( [Date], "Q" ) & " Trimestre" ,
"TrimestreAbrev", FORMAT ( [Date], "Q" ) & " Tri" ,
"TrimestreAbrevAno", FORMAT ( [Date], "Q" ) & " Tri " & FORMAT ( [Date], "YYYY" ),
"AnoTrimestre", FORMAT ( [Date], "YYYY" ) & " ." & FORMAT ( [Date], "Q" ) & " Tri"
)