Linked tables in datamodel

[TomBond77]

Hi experts

I have two tables linked by a key field "Key_Date".

Table "Date" holds all dates. Table "InvoiceAnalysis" holds all dates for invoices. I have stored a table of both tables as Excel to check if records are plausible. 

In the app a table selected only on table "InvoiceAnalysis" and just that field "%Key_Date" it shows for 2022 only the first calendar day of each month although the Excel file contains more entries. The subset ration of table "InvoiceAnalysis" shows 9% which seems to be low. Any ideas how to fix this issue?

[vinieme12]

Either  your calendar is generated only for MonthStart Dates

or

You are only using the month Start Date in the key field instead of all dates in the months ie %Key_Date which is why only the 1st calendar date data is getting linked