3.3.5.2 - NOT First Week of Timescale

Options
Erpacca
Erpacca Member, ALL USERS, Partner, Certified Model Builder Posts: 4 New Contributor

Good evening,

 

I am asking for a hint, according to the formula for the item NOT First Week of Timescale ?.

 

I saw here prompted that the solution lies in the OFFFSET formula, but I have something that is not correct.

I decided by forming 3 items, but I'm not sure if this is correct.

 

Now everything looks something like this (in the picture)

 

Best regard,

Comments

  • Erpacca
    Erpacca Member, ALL USERS, Partner, Certified Model Builder Posts: 4 New Contributor

    @ChrisAHeathcote  Why PREVIUS? The tip is about using the post. Previus will simply convey to me the meaning of the past time period. 

     

    Isn't the tooltip talking about the item "NOT First Week of Timescale?" all the weeks after "First Week of Timescale?" must be TRUE.

     

    If i choise in First Week of Timescale? Week 2 FY20, then my next week will become TRUE , but all future week will be FALSE.