top of page

inscreva-se

  • YouTube ícone social

DAX - CALENDÁRIO

Canal no Youtube criado por Amanda Nascimento 

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" 

)

    

bottom of page