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 n...
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:
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.