• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Last transaction date from each month

M

MBS

Member
Hi All,
Please refer attached sheet and let me know, more appropriate approach or method to get the last transaction date from each given month.
I tried to use if...else ... construction.

Thanks and regards
 

Attachments

  • Last Date of Month.xlsx
    18.3 KB · Views: 8
An alternative means would be to find the max date using Group By in PQ. Then joining that query back on the original source data as shown in the attached. I believe your solution is quicker.
 

Attachments

  • Last Date of Month.xlsx
    22.5 KB · Views: 4
I don't know if it matters, or will ever happen, but if there is more than one transaction on the latest day of the month, yours (@MBS ) will only show one of them. Alan's will show all of them.
In the attached a couple of other ways.
 

Attachments

  • Chandoo57084Last Date of Month.xlsx
    24.5 KB · Views: 6
You must log in or register to reply here.
Back
Top