Second Friday of the month formula

DMManalili
DMManalili
in Modeling

Hi, for your assistance please. How can I get every second Friday of the month? I created a line item Day identifier to get every friday but I need the second friday of the month. Thank you 🙂

 

DMManalili_0-1635845742633.png

 

Tagged:

Best Answer

  • ankit_cheeni
    ankit_cheeni
    Answer ✓

    Hi @DMManalili 

     

    Rank starts to behave peculiar when used against a time dimension. See this thread  for more details.

     

    What we did is use cumulate function to identify the second friday of the month. This is how the logic looks like:

    ankit_cheeni_0-1635851008340.png

    The idea was to identify second friday but also reset the identification when the month changes (see Dec month dates vs November).

    Here is the blueprint for your perusal:

    ankit_cheeni_1-1635851096398.png

     

    Let me know if this is helpful 

Answers

Categories