DM_CALENDARIO = ADDCOLUMNS( CALENDAR( MIN( Tabela[Data]), NOW() ), "Ano", YEAR([Date]), "Mês", FORMAT([Date], "MMMM"), "Mês Ord", MONTH([Date]), "Mês Rotulo", CONCATENATE( LEFT( UPPER(FORMAT([Date], "MMM")),1), RIGHT( FORMAT([Date], "MMM"),2) ), "Dia", DAY([Date]), "Dia Ord", DAY([Date]), "Dia/Mês", FORMAT([Date], "dd/mmm"), "Dia/Mês Ord", FORMAT([Date], "mmdd"), "Dia/Mês/Ano", FORMAT([Date], "dd/mmm/YY"), "Mês/Ano", FORMAT([Date], "MMM/YYYY"), "Mês/Ano Ord", FORMAT([Date], "YYYYmm"), "DataJoin", FORMAT([Date], "YYYYmmdd"), "Semana", FORMAT([Date], "w"), "Semana Rotulo", SUBSTITUTE(FORMAT([Date], "dddd"),"-feira",""), "Semana Ano", FORMAT([Date], "ww"), "30+", IF( TODAY()-30 < [Date], FORMAT([Date], "dd/mmm/YY"), "30+" ), "30+_Ord", IF( TODAY()-30 < [Date], FORMAT([Date], "YYYYmmdd"), "00000000" ), "Mês Atual", IF( FORMAT([Date],"MMM/yyyy") = FORMAT(NOW(),"MMM/yyyy") , "Mês Atual", FORMAT([Date],"MMM/yyyy")), "Ano Atual", IF( FORMAT([Date],"yyyy") = FORMAT(NOW(),"yyyy") , "Ano Atual", FORMAT([Date],"yyyy")) )