Not sure if this belongs here or in the DAX forum, but I am trying to create a report with 2 date slicers that are not related to each other. Date Table 1 has a one to many relationship with the Fact table. Date Table 2 has an inactive 1 to many relationship with the date table. I have 2 questions:
- Is this the recommended approach?
- If so, how would I calculate using the inactive relationship. I’ve tried various permutations of the DAX below:
Compare Amount =
ALLSELECTED (DimDateCompare[Year Month Name]), USERELATIONSHIP(DimDateCompare[Date], FactPLData[GLDate])