Hi!
You could look at the periodToDate functions. For example periodToDateSum would give you the sum up to a specific enddate.
In this article (see the PeriodToDate section), I use periodToDateSum to get data up to a specific day of the month. My example compares the previous year (so November 2022 vs November 2021), but you would just need to change the period to MONTH to compare November to October.
Hope that helps, please mark my answer as a solution if it does,
Thanks 
1 Like