Need your assistance to write a statement on how to get the last record for last X months.
I.e. Current Month = Jan 2021
Previous 6 months = July 2020
** Between Aug 2020 to Dec 2020, and between Feb 2020 to May 2020, there is no record of trade price in table.
Below screenshot of desired output in yellow.
Thanks for the help!