Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Calendar with specific start date and end date: end of current year

Hello! I am trying to create a dynamic calendar table with a start date of 01/01/2017 and the end date always the end of the current year, but I just keep getting it wrong. The one I use now goes to...
Need Help
  • BobBI's avatar
    BobBI
    6 years ago

    Hi Eden,

     

    Try this DAX , Create 'new table' under modeling

    Calender = CALENDAR(
                          Date(2017,01,01),
                          Date(YEAR(today()),12,31)
                       )

    You can additional columns by using ADDCOLUMN() function or just by adding new column (Right click--> New column) in the Calendar directly

    Hope if would help

    Thanks
    Sukhi

BobBI's avatar
BobBI
Icon for Resolver III rankResolver III
6 years ago

Hi Eden,

 

Try this DAX , Create 'new table' under modeling

Calender = CALENDAR(
                      Date(2017,01,01),
                      Date(YEAR(today()),12,31)
                   )

You can additional columns by using ADDCOLUMN() function or just by adding new column (Right click--> New column) in the Calendar directly

Hope if would help

Thanks
Sukhi

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you thank you!!