Forum Discussion

extri13's avatar
extri13
Icon for Helper I rankHelper I
10 years ago
Solved

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

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 follo...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    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

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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's avatar
BhaveshPatel
Icon for Super User rankSuper User
10 years ago

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