earlier function error again

[Anonymous]

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. 

[Greg_Deckler · Accepted solution]

@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.

[Anonymous]

Thanks! Indeed I created the DAX formula in Power BI data view, not in query editor. I thought i have created a new column, but you are right, it seems to be a measure formula. Now the earlier function works when I create it under a new column. 

[amitchandak]

@Anonymous , hope you are creating a column, not a measure.

Try like this

new column = , sumx(filter(Table,Table[ID] =earlier(Table[ID])) ,Table[value])