Results 1 to 7 of 7

Thread: Power Query Custom Column Formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    Dear Aflatoon,

    I moved your code to the end of my code a second time (I tried before but must have done something wrong), and now it worked!

    This is just great - many thanks, this is very much appreciated.

    So if I rate this thread, this is how I rate your support, right?

    Is there a way to modifie the code so that the calculation starts at the end of the table (oldest date)? The top of the table contains the most recent date. So what I need is actually the other way around. I just tried "
    then [NAV] / PreviousRows{[Index] + 1}" instead then [NAV] / PreviousRows{[Index] - 1} and it seems to work.

    Thanks,
    Kai
    Last edited by KaiA; 01-29-2024 at 07:12 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •