Forum Discussion
Resolver IILinking 2 or more dates to one Master Calendar (USERELATIONSHIP)
Kudo KingpinI have been having the same exact problem, but the changing of the Date columns to "Date" instead of "Date/Time" didn't work (after I read this post I was confident that would fix it) - I'm getting a (BLANK) when I create the measure I'm looking for.
I have an inactive relationship between the columns, and my measure looks like:
New Oppys Created = CALCULATE(SUM(Opportunity[Annual_NCVI__c]),Opportunity[New_Renew__c]="New",USERELATIONSHIP(Opportunity[CreatedDate],'Date'[Date]))
Any ideas? This is driving me nuts and I can't figure out what's wrong, everything looks like it should to me.
BKnecht Does it help if you change that middle argument to a full FILTER statement?
New Oppys Created = CALCULATE(
SUM(Opportunity[Annual_NCVI__c]),
FILTER(Opportunity, Opportunity[New_Renew__c]="New"),
USERELATIONSHIP(Opportunity[CreatedDate],'Date'[Date])
)
Also as previously suggested make sure that your date table's range actually covers all possibilities in the Opportunity table.
- BKnecht
For whatever reason the FILTER statement doesn't give me what I want. But, I found I had Date Ranges that weren't accounted for in some of the other relationships connected to the date table - even if the relationship I was using had the ranges covered for, some of the other relationships didn't - and it looks like that's what was breaking it.
Thanks a lot for the quick response!
Yeah when you have multiple connections to the same date dimension you can get some odd misbehaviors that are very hard to track down. Especially when you're using inactive relationships that are toggled by USERELATIONSHIP and you have to compare two or more different relationships in one measure. *glares angrily at another window*