As Andy suggested you can concatenate if there are many fields with common names and common values.
And for your Date field, create a Datekey for one of yous field.
Ex: You may have row effective date or a start date....
you'll have this below in Master Calendar....
trim(date(YOURMASTERCALENDARTEMPDATE,'YYYYMMDD')) as [DateID],
In your table you concatenated use same script
trim(date(YOURFACTDATEFIELD,'YYYYMMDD')) as [DateID],
This would link to master and I guess it should work... you don't need to map 2 dates fields, 1 date field should be ok.
Or maybe an expert on this can help you.
But If I were you, I'd do as above.
To be more clear, it would be better if you can paste the screenshot of your data model or a sample file?