I'd prefer loading both month sources as dual month values, i.e.
LOAD Month(Date#(monthfield,'M')) as monthfield From OneFile; LOAD Month(monthfield) as monthfield From OtherFile;
If this field is already loaded as dual date from your Excel source, otherwise
Month(Date#(monthfield,'MM/DD/YY')) as monthfield
Month(Date#(monthfield,'MMM-YY')) as monthfield
might be necessary.
hope this helps
Thanks Marco - I will take a look and try this out.
Does this take into account that in one file, the monthfield facts/values are 1, 2, 3, 4, and in the second file the monthfield has facts/values which are Jan-16, Feb-16 - and these are formatted fields, so behind them lies the full date 01/01/2016 which is then displayed in Excel as Jan-16?