Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have hit a wall and need another set of eyes on this. I don't know why I am getting the "Field not found" error.
DateRangeBridge:LOAD DistinctNum(Date#(MeasureMonthDTS, 'YYYY-MM-DD')) & Num(Date#(MeasureMonthEndDTS, 'YYYY-MM-DD')) AS BridgeKey,MeasureMonthDTS,MeasureMonthEndDTSResident Fact;
Left Join (DateRangeBridge)
LOAD DateDTResident CalendarWhere Date(DateDT) >= Date(MeasureMonthDTS) and Date(DateDT) <= Date(MeasureMonthEndDTS);
Field 'MeasureMonthDTS' not found