Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

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

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

amitchandak's avatar
amitchandak
Super User
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Column = Format(Table 3[Date],"MMM-YY")
    tried
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Column 2 = Format('Table 3'[Date],"MMM-YY")
       
      added using this formula but unable to add it to the hirarchy
       
      Shree