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))
Column = Format(Table 3[Date],"MMM-YY")
tried
Column 2 = Format('Table 3'[Date],"MMM-YY")
added using this formula but unable to add it to the hirarchy
Shree