Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have a variety of different dates across multiple tables. i want to link them all to a master calendar but i am struggling to do it. i have tried creating a calendar per table then linking those to a master calendar but i cant seem to get it working.
is anyone able to suggest anything?
i have attached a sample.
many thanks
Have a look here: Canonical Date.
- Marcus
I have been working on a model with multiple dates using the blog post Canonical Date.suggested above by Marcus and have found it very useful.
Hi,
I created an example qvw using technical Canonical Date. First the quality of your data is poor and I use Campaign_ID to Primary Key, and don't Load rows if Campaign_ID doesn't exists. I used start_date to Principal Date and only is an idea.
The filters on list box always show the first value column of Table Box.
Repeat, it's only an idea of structure but the data is not correct.
Regards,