Forum Discussion
Solved
Role Playing Date Dimensions?
I'm using the following approach to create roleplaying date tables and wanted to run it by you all for feedback. Here's the scenario: - I have a source data table that has OrderDate and ShipDat...
- No [email protected] recommended solution is to use 2 calendar tables...but I find myself using one calendar table with USERELANTIONSHIP for the other dates most of the times...It depends mostly on how you will report them & the distribution of dates.Either way 2 calendar tables is easier to maintain in complex data models and many date columns.
But I prefer creating a second inactive relationship with ship dates using USERELANTIONSHIP so I can have both of them in the same graph using column from one calendar table
Is a matter of preferences..and habits
Typically, I also prefer to create multiple tables in the Power BI model.
E.g., I create one query that generates a "base" date table. Then I duplicate it by creating more queries that simply reference the base date query, then change the names of the columns.
Because I want the different date dimensions to have different names, like "Order Date" (with "Order Year," "Order Month," etc.) and "Ship Date" (with "Ship Year," "Ship Month," etc.). I think this provides a lot of clarity, when you are showing dates on reports/dashboards. (And I don't think you can do this, if you use a single date table, with multiple relationships plus USERELATIONSHIP.)