[Basic Question] EARLIER/EARLIEST refers to an earlier row context which doesn't exist

[extri13]

Dear BI users,

I can not see EARLIER function working rightly (like below captured image).

Could you please tell me my wrong on the use of EARLIER?

Actually, I am creating MoM measures following below article.

However, I found everytime the error message whenever any use of EARLIER function.

• http://www.daxpatterns.com/time-patterns/#complete-aggregation-patterns

So, I just made a very simple measure and it also show the same error message

even the simple measure is just a example of an article

• https://blog.crossjoin.co.uk/2011/09/11/earlier-addcolumns-and-row-context/

Measure and error of EARLIER function

Sincerely,

Lee, Hong Gwoo

[v-haibl-msft · Accepted solution]

@extri13

As BhaveshPatel said, EARLIER and EARLIEST are usually used in calculated column. I’d like to recommend this article to you. It should be able to make you understand them more clearly.

And EARLIER can also be used in DAX measure in some situations. You can take a look at this article.

Best Regards,

Herbert

[BhaveshPatel]

Thank you Herbert,

Yes it can be used in DAX Measures too but In that specific case, It was supposed to be used for calculated column.

Regards

Bhavesh

[BhaveshPatel]

Hi

It seems to me that instead of creating a calculated column, you are creating a measure. 

To Create a Calculated Column, 

Go to the Table and Right Click, Select New Column and Put the same syntax in there.

This will give you the right results.

Regards,