Relationship trouble Calendar Table

[Anonymous]

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

[v-huizhn-msft]

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

[v-huizhn-msft · Accepted solution]

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