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

[Anonymous]

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 today only and I cant seem to update it properly.  Any help would be VERY appreciated!

THANK YOU!

[amitchandak]

Calendar(date(2017,1,1),date(year(today()),12,31))

[BobBI · Accepted solution]

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]

Thank you thank you!!