Calendar Table

[Anonymous]

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

[amitchandak]

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.

[Anonymous]

 i have created a new column and added this formula getting error..failed to resolve name date.. Format(date,"MMM-YY")

[Anonymous]

Error Failed to resolve name 'Date'. It is not a valid table, variable, or function name.

[amitchandak]

You need to give tablename[columnname] from your table.

[Anonymous]

Column = Format(Table 3[Date],"MMM-YY")

tried

[Anonymous]

Column 2 = Format('Table 3'[Date],"MMM-YY")

added using this formula but unable to add it to the hirarchy

Shree

[Anonymous]

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))

[amitchandak · Accepted solution]

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))