Forum Discussion

Advocate II

9 years ago

Solved

Working with 2 time dimensions

My data comes from a CSV, not a pristine star schema. I have requests that get opened then closed. The data gives the opening and closing date for each RequestID. REQUESTID | OPEN_DATE | CLOSE_DAT...

MalS
9 years ago
You can use the USERELATIONSHIP function when you need to use the inactive relationship in your measures.

Here's a good explanation: https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

Resolver III

9 years ago

You can use the USERELATIONSHIP function when you need to use the inactive relationship in your measures.

Here's a good explanation: https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

Community Champion

9 years ago

The text of the above link is correct but I think the link itself contains a few extra characters causing it to give a 404 error

Try this instead

https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

Also take a look here

http://exceleratorbi.com.au/many-many-relationships-dax-explained/