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?
Thanks
Tyles
Hi @Tylesftw,
Think you’ll be interested in the summit that’s currently running, Sam covers the USERELATIONSHIP…
This article and video has been posted by Alberto on sqlbi.com
Guy
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
Cristian
cheers all, reading up with the content you have linked 
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!