I am attaching a workbook based off Superstore sample, that might spark some ideas. It basically uses a moving table calc to return the average sales/profit for the previous 5 months, together with the current month sales/profit. As it is a moving table calc, you cannot filter the months directly (you will lose the previous months data), but instead use some table calc proxy again, like window_max(min([Order Date])) to do the trick.
Hope this helps a bit!
Vlad, why is the file 23MB?
EDIT: Had a look anyways. Great example. Unfortunately I wasn't able to replicate the technique on my example. Instead I just made two different charts and put them next to each other in a container.
Still a good lesson about moving calcs. Appreciate the help. Here's my inelegant solution
That's really weird Louis, I'm scratching my head on why the file grew so much in size? No idea! Maybe if you post some sample data in a twbx file I may try to help further. Or if you are heading towards a Dashboard, have a look at what actions may do for you.