Forum Discussion
Resolver IILinking 2 or more dates to one Master Calendar (USERELATIONSHIP)
Hi RJ, I have tried the instructions provided, however for some weird reason, I get a group of total at the top without dates. This is despite each of my rows in the Application table has dates.
Here is how I have linked my DateTable, where the active link is between Date and Application Received Date. The inactive date is between Date and Application Offer Sent Date. With the cross filter direction, I have tried both "Single" and "Both", but to no avail.
Here is the output that I am getting. Noticed that next to 6, there isn't any Year or Month information.
Any ideas? Any assistance would be much appreciated. Thanks.
Have you made absolutely sure that all of the dates that show up in the Application table are covered by the range in the Date table?
Hi Anonymous, thanks for the hint. I found out that those 6 anamolies were due to the time stamps. Because I have used DateTable = CALENDAR(MINX('Application','Application'[Application Received Date]), TODAY()) to generate the Date table, the default timestamp is 12:00:00 AM. Hence, any row in the Offer Sent Date without 12am could not be matched.
Is there a way to force USERELATIONSHIP() to only match on the date portion and not the time?
I don't think so. The relationship exists on the tables themselves, not the particular measure being executed on them. I recommend separating date and time into separate columns. If you need a full date/timestamp then perhaps just make a custom column containing only the date from that, and use that to create the relationship.