Forum Discussion
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 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 |
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:
4 Replies
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.
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:
What formula are you using and are you creating the table in Power Query or DAX?
