Creating a table with three different distinct excels that has the only common data is date.

Hi,

Create a Calendar Table with calculated column formulas for Year, Month name and Month number.  Sort the Month name by the Month number.  Create a relationship (Many to One and Single) from the Date column of each table to the Date column of the Calendar Table.  In the third table, rename IP to Inpatient and OP to Outpatient.  Creata table (Patient type) with 2 rows - inpatient and outpatient.  Create a relationship (Many to One and Single) from the Patient type column of all three tables to the new patient type table.  To yuor visual, drag patient type from the new table and Date from the Calendar Table.  Write these measures

T = sum('target report'[target])

F = distinctcounta('Finalized report'[patient id])

Hope this helps.