Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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:
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
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:
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
What formula are you using and are you creating the table in Power Query or DAX?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |