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))
8 Replies
You can create a date table using the calendar function. Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
User format function get data in any format
Format(date,"MMM-YY")
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.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))