Forum Discussion

unclejemima's avatar
unclejemima
Post Patron
8 years ago

3 date tables relationship???

I have 3 tables with dates. 

 

-My calender table, with all my DAX calender formulas.

-Trandata table with "datadate" column.

-Invoice table with "nvdate" column, what is the date of the invoice.

 

There is a relationship between invoice and trandata, tieing the unique number of the invoice to the trandata table what shows the individual transactions lines on the invoice.

 

Then I have the date relationship between trandata(datadate) and calander(date)

 

This works fine if I try and do any reporting on date from trandata...but I can't run any date related reports from the invoice table.  When I try and create another relationship between invoice(nvdate) and calender(date) i get an error that I can't have 2 relationships as there is already one between trandata and calender...

 

Any ideas? 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    should be able to set both of your relationships as both directions 

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi unclejemima,

     

    Based on your description, which kind of relationships have you built between table 'Invoice' and 'Trandata', table 'Trandata' and 'Calendar'? Could you privide more details about your table structure?

     

    Regards,

    Jimmy Tao