Forum Discussion
Common Filter for Different Data Source or Table
Unless there is a specific reason to avoid relationships (I can't think of one!) you'll need to use them..
A date dimension is commonly used for this.. You'll want a table with all the dates in a range your interested in, and you can have columns which have the different ways you may want to cut the data:
DateId Date Year Month Day Year Month 1 01/01/2015 2015 January Thursday Jan-15 2 02/01/2015 2015 January Friday Jan-15 3 03/01/2015 2015 January Saturday Jan-15 4 04/01/2015 2015 January Sunday Jan-15 5 05/01/2015 2015 January Monday Jan-15 You can either create a fixed table in excel, or if you want to get fancier you can generate is dynamically.
Join this table to your two excel tables and insert the DateId into them - then you can create the relationships between them in the relationships editor using the DateId key. The advantage of this approach is that you have a common, continuos set of dates and ways to slice the data
Unless there is a specific reason to avoid relationships (I can't think of one!) you'll need to use them..
A date dimension is commonly used for this.. You'll want a table with all the dates in a range your interested in, and you can have columns which have the different ways you may want to cut the data:
| DateId | Date | Year | Month | Day | Year Month |
| 1 | 01/01/2015 | 2015 | January | Thursday | Jan-15 |
| 2 | 02/01/2015 | 2015 | January | Friday | Jan-15 |
| 3 | 03/01/2015 | 2015 | January | Saturday | Jan-15 |
| 4 | 04/01/2015 | 2015 | January | Sunday | Jan-15 |
| 5 | 05/01/2015 | 2015 | January | Monday | Jan-15 |
You can either create a fixed table in excel, or if you want to get fancier you can generate is dynamically.
Join this table to your two excel tables and insert the DateId into them - then you can create the relationships between them in the relationships editor using the DateId key. The advantage of this approach is that you have a common, continuos set of dates and ways to slice the data
Thanks man for your time, will try to incorporate that.
Cheers,
Sami