How to calculate Monthly aggregates from daily data

  • Hi Jeff Good Morning,

    Any advise please

    Thank you,

    asiti

  • Any Advise? please

     

    Week NewMembers FUMembersCounts EUMembersCount

    Oct-03-2021 To Oct-09-2021 0 0 0

    Sep-26-2021 To Oct-02-2021 0 0 0

    Sep-19-2021 To Sep-25-2021 0 0 0

    Sep-12-2021 To Sep-18-2021 0 0 0

    Sep-05-2021 To Sep-11-2021 0 0 0

    Aug-30-2021 To Sep-04-2021 5 3 2

    ...

    ....

    goes to min(Filedate) week

     

    Thanks

    asiti

     

     

  • This was removed by the editor as SPAM

  • asita wrote:

    Any Advise? please

    Week NewMembers FUMembersCounts EUMembersCount Oct-03-2021 To Oct-09-2021 0 0 0 Sep-26-2021 To Oct-02-2021 0 0 0 Sep-19-2021 To Sep-25-2021 0 0 0 Sep-12-2021 To Sep-18-2021 0 0 0 Sep-05-2021 To Sep-11-2021 0 0 0 Aug-30-2021 To Sep-04-2021 5 3 2

    ...

    ....

    goes to min(Filedate) week

    Thanks

    asiti

    Apologies.  I lost track of this thread.  Do you still need help with this?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 4 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply