Forum Discussion
Dim_date table
Hi everyone,
I am creating a Dim_date table based on min, max date from another column. How I can include hour, minute, and second in this Date column? The photo below just shows the default time - it's not what I want.
Thanks.
2 Replies
Hours and Minutes don't belong in a Date table.
Hi alicemolk ,
The CALENDARAUTO returns a table with a single column named "Date" that contains a contiguous set of dates. The range of dates is calculated automatically based on data in the model.
More details: CALENDARAUTO function (DAX) - DAX | Microsoft Learn
I have also found a similar post, please refer to it to see if it helps you.
Solved: Create table with date and time - Microsoft Power BI Community
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
