Forum Discussion

anilkumarpoda's avatar
anilkumarpoda
Icon for Resolver I rankResolver I
3 years ago
Solved

Can we establish relationship between different date columns?

Hi, in a health policy database there are 3 tables Scheme - With scheme details along with start date. Membership - Employe Membership details with start date. Usage - Member ship utilization deta...
Need Help
  • anilkumarpoda's avatar
    anilkumarpoda
    3 years ago

    I got the answer from another forum. We can create a date table and map date column to date columns in other tables. But only one connection will be active. To use inactive connections in DAX we can use  USERELATIONSHIP() function.

     

    Total RP by Start Date = 
    CALCULATE(
        [Total RP],
        USERELATIONSHIP('RP'[WorkflowStartedDate], Dates[Date])
    )
anilkumarpoda's avatar
anilkumarpoda
Icon for Resolver I rankResolver I
3 years ago

I got the answer from another forum. We can create a date table and map date column to date columns in other tables. But only one connection will be active. To use inactive connections in DAX we can use  USERELATIONSHIP() function.

 

Total RP by Start Date = 
    CALCULATE(
        [Total RP],
        USERELATIONSHIP('RP'[WorkflowStartedDate], Dates[Date])
    )