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

[hiba_aziz]

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!

[PijushRoy]

Hi @hiba_aziz 

I am not sure about CurrentID, datecurrent, FirstDateOverCostAB you are using, are these variable in DAX
Please create a PBIX with few sample record and share the google drive or dropbox or onedrive link

[hiba_aziz]

@amitchandak    @Idrissshatila @Ritaf1983 @Daniel29195 @PijushRoy