Forum Discussion
earlier function error again
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 - 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.
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.