Date, Day, Time by the hour table

[driskbr]

Hello all, new Power BI user trying to learn the ropes.

I've searched and searched and haven't been able to find what I am looking for, I'm hoping it exists.

I need a Date table that will return the following info with the ability to filter or select ranges for each category. I have seen tables that have part, but not all of the following: Year, Month & Month number, Day & Day of the week (Monday, Tuesday, etc..., & Hour (0-24).

Thanks for the help. 

[v-cgao-msft · Accepted solution]

Hi @driskbr ,

Please refer to the sample file:

Date and time functions (DAX)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[driskbr]

Thanks so much Gao!

As I mentioned in my post, this is all new to me, so being able to examine your example was very helpful!