Forum Discussion

sv11's avatar
sv11
Icon for Helper I rankHelper I
7 years ago

Tables Relationships

Hi,   I have 2 tables being pulled from different databases.    I managed to connect them on a Unique ID - "ExtnID", and I am able to filter the report using this.   These 2 tables have a diffe...
Need Help
yelsherif's avatar
yelsherif
Icon for Resolver IV rankResolver IV
7 years ago

I suggest one of 2 solutions:

1. create a calculated table for combined dates, e.g:
dates = SUMMARIZE(UNION(table1,table2),[date])

Then link this table to both data tables with the date column in both. set filtering direction as single. you can then apply filter to the "dates" table created above.

 

2. depending on the consistency of dates in both tables, you can still create an inactive relation between the two tables directly and use special DAX expressions to activate this relation when needed, e.g: 
calculate(count(table1[ID]), USERLATIONSHIP(table1[date],table2[date]))

  • sv11's avatar
    sv11
    Icon for Helper I rankHelper I
    7 years ago

    yelsherif Thank you for your suggestion.

     

    In your 2nd proposed solution, is it possible to activate this relation by using a date slicer?