Posts in tags “Dimensions”
Posts
Time Dimension
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.