Previous Period Lookup

CommunityMember113484

Hi

I have a module where I look up the last period with data entered - line item Previous Non-Blank.  

My formula is as follows - why in Q4 FY20 and Q1 FY21 is the previous non-blank not picking up Q3 FY20 and Q4 FY20?

 

Formula: IF Last Quarter Entered = Last Quarter Entered[SELECT: TIME.All Periods] AND ITEM(Time) >= Last Quarter Entered[SELECT: TIME.All Periods] THEN PREVIOUS('Previous Non Blank') ELSE PREVIOUS(Last Quarter Entered)

 

 

Thanks

alexpavel

@CommunityMember113484  I would use this formula instead:

 

IF PREVIOUS(Data) <> 0 THEN PREVIOUS(ITEM(Time)) ELSE PREVIOUS('Previous non Blank')

 

 

Hope it helps

Alex

 

CommunityMember113484

Worked a treat, thank you!