Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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. 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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])

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.