Forum Discussion
earlier function error again
Hi, I try to create a new column in query editor however, the earlier function generates an error. Thanks for help! arlier function doesn't work.
Anonymous - There's a lot going wrong here. First, EARLIER is DAX and thus does not work in Query Editor because Query Editor uses M code, not DAX. Two, that screen shot is not the Query Editor. Third, it looks like you are creating a measure and not a calculated column and that's likely why you don't have an earlier context for EARLIER.
amitchandak
Super User
Super UserAnonymous , hope you are creating a column, not a measure.
Try like this
new column = , sumx(filter(Table,Table[ID] =earlier(Table[ID])) ,Table[value])