Forum Discussion

MCacc's avatar
MCacc
Helper IV
2 years ago
Solved

Build calendar using year

Hello, I'm trying to build a calendar where the min date starts 20 years ago from this year, and max date is 5 years ago from this year.   So because I'm 2024:    The first date is:  01/01/2004 ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    MCacc 

     

    CalendarTable =
    VAR MinDate = DATE(YEAR(TODAY()) - 20, 1, 1)
    VAR MaxDate = DATE(YEAR(TODAY()) - 5, 12, 31)
    RETURN
    ADDCOLUMNS (
    CALENDAR (MinDate, MaxDate),
    "Year", YEAR([Date]),
    "Month", MONTH([Date]),
    "Day", DAY([Date]),
    "MonthName", FORMAT([Date], "MMMM"),
    "Quarter", "Q" & FORMAT([Date], "Q")
    )

Khushidesai0109's avatar
Khushidesai0109
Skilled Sharer
2 years ago

Hiii MCacc 

CalendarTable =
VAR StartDate = DATE(YEAR(TODAY()) - 20, 1, 1)
VAR EndDate = DATE(YEAR(TODAY()) - 5, 12, 31)
RETURN
ADDCOLUMNS (
    CALENDAR(StartDate, EndDate),
    "Year", YEAR([Date]),
    "Month", MONTH([Date]),
    "Day", DAY([Date]),
    "MonthName", FORMAT([Date], "MMMM"),
    "Quarter", "Q" & FORMAT([Date], "Q")
)
this dax would help you to make a calendar dynamically as the year goes on...

Did I answer your question? Mark my post as a solution! And Kudos are appreciated