Forum Discussion

Roinka's avatar
Roinka
Helper I
7 years ago
Solved

One active relation when we need 2

Hi, I have a calendar dimension which holds the date and name of the day of the week and a sales fact table which holds details per sales. The sales table include both an order date and a stock date...
  • AlB's avatar
    7 years ago

    Hi Roinka 

    Have you checked out USERELATIONSHIP? You could have one relationship active and the other inactive and activate the latter through USERELATIONSHIP in a CALCULATE

    https://dax.guide/userelationship/