OLE DB or ODBC error: something is wrong with one or two fields

Hello All,

I'm getting this error, when trying to create a calculated columns.

I'm connected to two data sources: a live connection to Analysis service and an imported table.

here  is the dax that is causing the issue:

CALCULATE(
SUM(table 1 [cost]),
table 1 [ID] = CurrentID,
table 1 [date] >= datecurrent,
table 1 [date] <= FirstDateOverCostAB
)

Note: Table 1 has over 10 million IDs.

Appreciate your help!