Forum Discussion
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...
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/
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/