I'm trying to link Quarter and month together. The quarter is from a different table file (I had to create an extra excel sheet to link month and quarter because a customer counts quarter differently, (see below), but that shoudn't be a problem since the table file also has month names and thus links the two tables together.
Feb till Apr - Q1
May till Jul - Q2
Aug till Okt - Q3
Nov till Jan - Q4
Date(Date) as Date,
Month(Date) as Month,
Month(Month) as Month,
When I look at my script, it seems correct. But there still no link. If I click on aug I should see Q3. but that doesn't work.
Have you checked that the two load statements are returning equivalent data. There are serveral reasons why they may not be, including:
Non-intersection between the source dates
Different formats for the dates
Be careful of using Month to link these tables - this will link January 2011 and January 2010 to the same quarter. The common practice is to link on Date and create a master calendar along the lines of the previous post.
Hope this helps
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Thanks for your help!! And sorry for the late response. Loading a full calendar works. However, I still need to find a way to group aug, sept, okt as a third quarter. Normally the third quarter should be juli, aug and sept. Unfortunately the customers wants it differently, that’s why I need to find a solution.