For your scenario a 'Scaffold' datasource is needed
which would contain rows for every possible combination
of the [Name] and [Date] dimensions.
Such a datasource could be made by cross-joining
the Master File 1 table with the (daily) Calendar one.
Then the Data File 2 table could be left-joned to the Scaffold
by both [Date] and [Name] dimensions.
Please find the attached as an example.
Allocations_v10.2_YF.twbx 17.8 KB