Forum Discussion
OLE DB or ODBC error: [Expression.Error] We cannot apply operator .. to types Null and Number..
This is what I have typed and it works in power query without errors. let StDt = [STARTDATE], AllDates = {Number.From([STARTDATE])..Number.From([ENDDATE])}, StofMonthDate = List.Distinct( List...
The first statement has to be a Source statement. That source should have columns like STARTDATE and ENDDATE.
OR
You will need to allocate some value to STARTDATE and ENDDATE variables. The moment you say [STARTDATE], it expects it to come from a table.
The first statement has to be a Source statement. That source should have columns like STARTDATE and ENDDATE.
OR
You will need to allocate some value to STARTDATE and ENDDATE variables. The moment you say [STARTDATE], it expects it to come from a table.
Those are from my table. STARTDATE and ENDDATE are available in the table
Please post your complete query alongwith Source statement.