Have you tried something like this:
Crosstable (ForecastDate, ForecastUtilization, 2)
(ooxml, embedded labels, table is [Forecast]);
LOAD AutoNumber(Port) as PortKey,
Date(Date#([Report Date], 'M/D/YYYY')) as ForecastReportDate,
Date(Num#(ForecastDate, 'M/D/YYYY')) as ForecastDate
DROP Table Forecasttemp;
That certainly makes sense, and during the load I see it load it twice, but I have data with 2 different report dates which render as 'ForecastReportDate' and only one continues to show up (the first date). It's the same problem I've been having.
No synthetic keys, no errors.
Any other thoughts?