Forum Discussion

ale259's avatar
ale259
Helper I
1 year ago
Solved

Create a date table from scratch

Hello,   Thank you for this great community. I'm having trouble creating a data table from scratch. Is the correct step is to: 1. Creat a new table Then, click edit Then, I'm not sur...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi ale259  - you are using "Enter Data" to create a date table . not a good approach. Instead, you should use Power Query or DAX to generate a proper date table dynamically.

    it looks as like below image:

     

     

    DateTable = ADDCOLUMNS(
    CALENDAR(DATE(2023,1,1), DATE(2025,12,31)),
    "Year", YEAR([Date]),
    "Month", FORMAT([Date], "MMMM"),
    "MonthNumber", MONTH([Date]),
    "Quarter", "Q" & FORMAT([Date], "Q")
    )

     

     

    paste the above logic to create a date table.

     

    Hope this helps.

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi ale259  - you are using "Enter Data" to create a date table . not a good approach. Instead, you should use Power Query or DAX to generate a proper date table dynamically.

it looks as like below image:

 

 

DateTable = ADDCOLUMNS(
CALENDAR(DATE(2023,1,1), DATE(2025,12,31)),
"Year", YEAR([Date]),
"Month", FORMAT([Date], "MMMM"),
"MonthNumber", MONTH([Date]),
"Quarter", "Q" & FORMAT([Date], "Q")
)

 

 

paste the above logic to create a date table.

 

Hope this helps.