Dim_date table

[alicemolk]

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.

[Anonymous]

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.

[lukiz84]

Hours and Minutes don't belong in a Date table.