Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date Table

Hello! I need help with a  Date table based off my column labled Pick up date in My data.  When I recently created a table based off Guy and a Cube but it gives me values from 1989 - 2049. I Just n...
Need Help
  • DataZoe's avatar
    DataZoe
    4 years ago

    Anonymous 

     

    To create a date table in DAX, you can go to Modeling -> New Table and try this:

    Date = CALENDAR(MIN('TableName'[Pickup_Date]),MAX('TableName'[Pickup_Date]))

     

    Also make sure your Pickup_Date is a Date Type as well:

     

HotChilli's avatar
HotChilli
Community Champion
4 years ago

What formula are you using and are you creating the table in Power Query or DAX?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    DAX and the formula is Calendarauto (6)

    Var Base Calendar = CalendarAuto (6)
    Return

    Generate (BaseCalendar,
    Var Base date = Date

    Var Yeardate = Year (Base date)

    Var Month Number = Month (Basedate)

    Return Row (
    "Day", Base Date,
    "Year", Yeardate, ... repeat to Year Month