Today I’m showing you my Dim Time table with flexible minute granularity. I have both DAX and Power Query versions. Best Practices for Power BI dictate that dates and times be in separate columns. This lowers the cardinality of both the dates and times and makes the model more efficient. I prefer my Time dimension as a DAX-generated table, but having the Power Query version is handy if you need to mash it up with other data.

Calendar tables are possibly my favorite topic in the world of data modeling. I am obsessed with the pursuit of the perfect calendar. Perhaps this is because time is such a powerful and sometimes difficult dimension to master. Just when you think you have it all figured out, some intrepid user throws you a curve ball like deciding they need reporting with all Tuesdays aligned. One thing I know for certain is a good calendar table can solve a lot of problems, and it will be much easier for members of a team to work on each others reports if everyone uses the same calendar and follows some standard practices.