Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • January 10, 2017 at 5:47 pm in reply to: #7216

    eliwaite
    Participant
    • Started: 0
    • Replies: 3
    • Total: 3

    That is great, looks like we arrived at similar solutions. Really wanted a measure, but couldn’t get EARLIER to work even with SUMX.

    Thank you for your help.

    January 10, 2017 at 5:16 pm in reply to: #7210

    eliwaite
    Participant
    • Started: 0
    • Replies: 3
    • Total: 3

    I figured out a solution. I cannot seem to paste the formula without getting a Forbidden Error. Thus my solution is in the attached spreadsheet.

    If you see any errors, or know a better way of doing this I would love to learn more.

    Attachments:
    You must be logged in to view attached files.
    January 9, 2017 at 11:35 pm in reply to: #7202

    eliwaite
    Participant
    • Started: 0
    • Replies: 3
    • Total: 3

    Yes that is correct (including the day they bought the bike). One of the tricky things is some customers purchase more than one bike, such as Customer ID 7 in my example.

    Thanks – Eli

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)