Forum Discussion
When to create dimensions?
I have been given an excel file of data, nothing out of the ordinarly. Filtering will be done based on some of the columns in that file. Its easy to just import the file and with little or no work s...
There is a good discussion on this topic here:
When writing DAX expressions, it is certainly easier to manipulate the filter context of a dimension if it is contained in its own table. And time intelligence requires a standalone date table (assuming you don't use the auto-generated date table).