Previous Period Lookup

Options
CommunityMember113484
CommunityMember113484
in Modeling

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)

 

CommunityMember113484_0-1619694691630.png

 

Thanks

Tagged:

Best Answer

  • alexpavel
    alexpavel
    Answer ✓
    Options

    @CommunityMember113484  I would use this formula instead:

     

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

     

    alexpavel_0-1619698944906.png

     

    Hope it helps

    Alex

     

Answers

Categories