Forum Discussion
Calendar Table
can we get ready table for last 5 years Time/Fiscal Calendar/Normal Calendar table to import in Power BI also can we calculate Month and year column like Jan-19/18/17 Shree
Try
Table2 = CALENDAR(DATE(2016,1,1),DATE(2019,12,31))
You can change the start and end year as per your need
like 2015 -2025
Table2 = CALENDAR(DATE(2015,1,1),DATE(2025,12,31))
I have used below menitoned formula and created calendar table for 2018 and 2019 but wants to add 2016 and 2017 also
Table2 = CALENDAR(DATE(2018,1,1),DATE(2019,12,31))
Try
Table2 = CALENDAR(DATE(2016,1,1),DATE(2019,12,31))
You can change the start and end year as per your need
like 2015 -2025
Table2 = CALENDAR(DATE(2015,1,1),DATE(2025,12,31))