Multiple data sources with dates

[shearwatertroy]

Hey everyone,

More date filtering fun!

I have two database connections I also have two Excel documents with dates.

I have one master calendar, which I'm trying to control the filtering.

The issue I have stumbled upon is either have one of two situations.

Issue one: Multiple synthetic keys: This issue causes my values to triplicate themselves.

Issue two: If I go with the natural name of the excel document dates, they do not filter at all.

Any suggestions?