Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Calendario Vendas =
- ADDCOLUMNS(
- CALENDAR(MIN(Vendas[DATA VENDA]),MAX(Vendas[DATA VENDA])),
- "Ano", YEAR([Date]),
- "Mês Num", MONTH([Date]),
- "Mês", UPPER(FORMAT([Date],"mmmm", "pt-BR")),
- "Ano Mês Num", FORMAT([Date],"YYYY/MM"),
- "Mês/Ano", FORMAT([Date],"mmm/YY"),
- "Dia da semana Num", WEEKDAY([Date]),
- "Dia da semana", FORMAT([Date], "dddd", "pt-BR"),
- "Trimestre", QUARTER([Date]) & "º trimestre"
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement