Create a date dimension for date/time data

Question

Hi,&nbsp;I have a date column in my data source, type is date/time. see below:&nbsp;&nbsp;What is the proper way to create a dimDate based on this dataset so we can measure stuff up to minutes and seconds?&nbsp;

anonymous · Accepted Answer

Hi
&nbsp;
Please read this article. It will help you.
I had the same work as you to do this week and I managed with this
https://radacad.com/how-to-use-time-and-date-dimensions-in-a-power-bi-model#:~:text=Power%20Query%20Editor.-,Separate%20Date%20and%20Time,Under%20Date%2C%20Select%20Date%20Only.
&nbsp;

Forum Discussion

Create a date dimension for date/time data

1 Reply

Related content

Auto date/time vs manually created hierarchies

degenerate dimensions

Date/Time

SharePoint list - using created date / time in date filter?

How can I create a date/time slicer for date AND time.