Forum Discussion

RJ's avatar
RJ
Icon for Resolver II rankResolver II
10 years ago

Linking 2 or more dates to one Master Calendar (USERELATIONSHIP)

The master calendar is created as per this thread   http://community.powerbi.com/t5/Desktop/Possible-Tip-Trick-Dynamic-Date-Dimension-Table/m-p/8795#M1543   But sometimes there are two dates like...
Show and Tell
Tips and Tricks
BKnecht's avatar
BKnecht
Icon for Kudo Kingpin rankKudo Kingpin
10 years ago

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!

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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*