Posts tagged Power Query

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…

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…