Results 1 to 9 of 9

Thread: How to create a month ID in PQ

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte jazzista's Avatar
    Join Date
    Jan 2017
    Posts
    35
    Articles
    0
    Excel Version
    excel 2016

    How to create a month ID in PQ

    Hello... I am trying to create a custom column in my calendar table so that i can do date math with the month column: so i need months 1 thru 12 in the 1st year, then month 13 thru 24 in the second year, 25 thru 36 in the 3rd year and so on. Is it possible to do it dynamically ? I am attaching the desired result. Thanks in advance to this great forum. Regards
    Attached Files Attached Files

Posting Permissions

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