Help with Formula - Identify Previous Product by Year

[Anonymous]

Hello Community, 

Can you please help me writing a following DAX  Column .  I have following calculated column which identify previous product by Date . I need it by Year. 

Customer ID |      DATE               |  Product  | Previous Product 

   1                      1/Jan/2020           A                   -

   1                       2/ Feb/ 2020       B                   A

   1                      13 / Jan/ 2021      B                   -
   1                      14 / Feb/ 2021     A                  B

I tried using folloing formula but it is by date : I need it by year

Previous Product =

VAR MAX_Date =

CALCULATE (

MAX( 'Master_Table'[Dates]) ,

ALLEXCEPT('Master_Table','Master_Table'[ID] ,'Master_Table'[Dates]))

VAR PreviousDate =

CALCULATE(

MAX ('Master_Table'[Dates] ) ,

ALLEXCEPT( 'Master_Table' ,'Master_Table'[ID]) , 'Master_Table'[Dates]< MAX_Date)

VAR PREV_PROD =

CALCULATE(

MAX ( 'Master_Table'[Product] ) ,

ALLEXCEPT( 'Master_Table' ,'Master_Table'[CI]) , 'Master_Table'[Dates]= PreviousDate )

RETURN

PREV_PROD

[smpa01]

@Anonymous  try this

_prevProd = MINX(FILTER('Table','Table'[CustID]=EARLIER('Table'[CustID])&&'Table'[_year]=EARLIER('Table'[_year])&&'Table'[Date]<EARLIER('Table'[Date])),'Table'[Product])

[Anonymous]

Hi @smpa01 ,

Thankyou so much for the reply. 

I am looking continuous previous product.  The code you send is producing  only  first previous product in year.

[smpa01 · Accepted solution]

@Anonymous  sorry my bad, try this

_prevProd = calculate(max('Table'[Product]),FILTER('Table','Table'[CustID]=EARLIER('Table'[CustID])&&'Table'[_year]=EARLIER('Table'[_year])&&'Table'[Date]<EARLIER('Table'[Date])))

[Anonymous]

@smpa01  Thank you so much! It is really helpful