olivierhbh
Board Regular
- Joined
- Jun 22, 2015
- Messages
- 136
Hello all,
I read this post (The Ultimate Date Table - PowerPivotPro) and a few others, and I understand that in the mentioned cases it's quite useful.
Let's consider 2 tables Trades and Invoices, related by the trade id (1 trade has several invoices).
In my Trades table I can have the trade date, shipment date, setup_date and in my Invoices table I can have the setup date and the due date.
How should I include a date table in this model? How could I connect all my date fields to this date table?
I feel that I'm missing something there, could you help?
Many thanks,
Olivier.
(Example Workbook if needed : https://www.dropbox.com/s/962wo6xmda1ma7q/example_dates.xlsx?dl=0)
I read this post (The Ultimate Date Table - PowerPivotPro) and a few others, and I understand that in the mentioned cases it's quite useful.
Let's consider 2 tables Trades and Invoices, related by the trade id (1 trade has several invoices).
In my Trades table I can have the trade date, shipment date, setup_date and in my Invoices table I can have the setup date and the due date.
How should I include a date table in this model? How could I connect all my date fields to this date table?
I feel that I'm missing something there, could you help?
Many thanks,
Olivier.
(Example Workbook if needed : https://www.dropbox.com/s/962wo6xmda1ma7q/example_dates.xlsx?dl=0)