Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
1 year ago
Solved

Colander Table With Two Date Replationship

Hello, i have a calendar table linked to another table called "Total" via a column called Received date.   On some pages of my report, I want to use another date column from the "Total" Table.  Thi...
  • Jpss's avatar
    1 year ago

    You dont need a second date table. Instead, in this scenario, you create two relationships. 

    1) Active

    2) Inactive. 

    Where ever you need to use the inactive relationship, you can use Userelationship DAX Function