Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
my table has multiple rows for each date.
and when I use the master calendar codes and when the tables are automatically connected by [Complete Date], not all of the rows are picking up the Master Calendar data. actually more rows are missing the fields from the Master Calendar. How do I fix this problem?
Have you checked that your dates are not in fact timestamps that may not match with your master calendar dates?
A timestamp can be formatted as date using Date(), but the underlying value is keeping the time.
Have you checked that your dates are not in fact timestamps that may not match with your master calendar dates?
A timestamp can be formatted as date using Date(), but the underlying value is keeping the time.
Thank you! I aligned the format of dates in my fact table and calendar table and it works now!
Thanks!
David - I would advise you to close this thread by marking Stefan's response as the correct answer.