Advertisement
fellpz

Tabela_Calendar

Apr 13th, 2022 (edited)
1,516
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Calendario Vendas =
  2. ADDCOLUMNS(
  3.     CALENDAR(MIN(Vendas[DATA VENDA]),MAX(Vendas[DATA VENDA])),
  4.     "Ano", YEAR([Date]),
  5.     "Mês Num", MONTH([Date]),
  6.     "Mês", UPPER(FORMAT([Date],"mmmm", "pt-BR")),
  7.     "Ano Mês Num", FORMAT([Date],"YYYY/MM"),
  8.     "Mês/Ano", FORMAT([Date],"mmm/YY"),
  9.     "Dia da semana Num", WEEKDAY([Date]),
  10.     "Dia da semana", FORMAT([Date], "dddd", "pt-BR"),
  11.     "Trimestre", QUARTER([Date]) & "º trimestre"
  12. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement