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?