Hi,
I was working on new calculcated columns and everything was working fine. Yet after refreshing the data i get this error....
(in powerquery preview its loading perfectly)....
EARLIER/EARLIEST refers to an earlier row context which doesn't exist. OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table..
i was trying to integrate an iferror to the calculated column but its not fixing it....now im stuck an cannot refresh the data....and i also dont know exactly where is the error...because even after deleting the calculated column and relationships its still giving me the same error....
index =
IFERROR (
RANKX(
FILTER(
'Products',
'Products'[Parent] = EARLIER('Products'[Parent]) &&
'Products'[Marketplace] = EARLIER('Products'[Marketplace]) &&
'Products'[Targeting] = EARLIER('Products'[Targeting]) &&
'Products'[Campaign state (Informational only)] = EARLIER('Products'[Campaign state (Informational only)])
),
'Products'[Campaign name (Informational only)],
,
DESC,
DENSE
),
// Return blank if error occurs
BLANK()
)
EARLIER/EARLIEST refers to an earlier row context which doesn't exist. OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table..
The new data is exactly the same, no columns changed etc....just new numbers....the rest is exatly the same and its also loading in powerquery perfectly.
Also i realised after copy pasting the pbix file....its showing and old deleted calculated column with error....yet in my other files its not there....i think it might be hidden somehow.....anyway to fix it? thank you so much!!
I can still refer to deleted DAX/calculted columns i think this causes the error...
Thank you so much!
