Date Table

[Anonymous]

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 need values based off the column I have  

Data pull is from 1/1/2019 - 10/20/2021

Pickup_Date

1/30/2019

1/30/2019

1/31/2019

1/2/2019

1/3/2019

1/1/2019

1/1/2019

[HotChilli]

CALENDARAUTO is a clever function which looks at every date field in your model and creates a date table to cover the whole range. 

So you want more control over your table and that would use the CALENDAR function (taking 2 parameters, start and end).  You can hardcode those parameters with specific dates (using DATE function) or refer to a specific table in your model as per @DataZoe 's answer.

I'll let you have a go at solving it.

Get back to us if it's not happening for you.

[DataZoe · Accepted solution]

@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]

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

[Anonymous]

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