Power Query - Max date each month

[jon999]

Hi

I have a list and want to pick up the last date for each month and return that list into a table.

Thanks

Jon

 

[alansidman]

cannot manipulate data in a picture. Try uploading data to forum using XL2BB. See the link in my signature.

 

[sandy666]

maybe

 

[jon999]

Thanks. it worked.

 

[sandy666]

You are welcome
Have a nice day

btw. next time use XL2BB to post your example (source data and expected result)