Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Relationship trouble Calendar Table

hi guys,

 

I created a customized table name Date  and created a relationship to table GeneralJournal (name table FNVGeneralJournalAccountEntries)  table.

 

the linked columns are AccountingDate and Date . Its a Many to one relationship.

 

Unfortunatly i cant get any result based on the created relationship (see pictures below). What did i wrong?

 

Any suggestions?

 

Kind regards,

Rega Sanyoto

 

 

 

 

 

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    Please change the Single to Both in Cross filter direction, and check if it works fine. Because I can't get more details about your report based on your screenshot, please share more details (such as columns and values added into report) for further analysis if you still have any issue about it.

    Best Regards,
    Angelia

2 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    Please change the Single to Both in Cross filter direction, and check if it works fine. Because I can't get more details about your report based on your screenshot, please share more details (such as columns and values added into report) for further analysis if you still have any issue about it.

    Best Regards,
    Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous，

    Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

    Best Regards,
    Angelia