Now With USERELATIONSHIP

I was feeling pretty good with the result from Tuesday.I helped my customer out. I got a new DAX tool for my toolbox. Life was good. But then I got thinking, "But what if they want to know how many promotions started or ended in May?" "I need that relationship back!"

To tackle this, I created two relationships between DimDate and DimPromotion. One on the StartDate of DimPromotion and one on the EndDate. The key to doing this without breaking my previous measure was to make these relationships inactive.