Cumulative Measure - USERELATIONSHIP

possibly a noob question;

Instead of using the usual date field with the active relationship in my fact table to calculate cumulative sales, I want to use another date column (that has an inactive, many-to-one relationship), can I just apply the following dax code?

Cumulative Sales by Release =
CALCULATE( [Cumulative Sales],
USERELATIONSHIP( Dates[Date], Fct_Sales[Dates Use] ) )

Where Dates Use = the new date column?


Hi @Tylesftw,

Think you’ll be interested in the summit that’s currently running, Sam covers the USERELATIONSHIP…

1 Like

This article and video has been posted by Alberto on


Hello @Tylesftw,

Short answer is “it should work” if the model is right.
You shod really see today’s Summit video linked by @Melissa and confirm you have the same situation/model


cheers all, reading up with the content you have linked :slight_smile:

Hi @Tylesftw, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!