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