You need a parameter to as month selection, this will be the easiest way to achieve what you expected.
Please find my solution attached as well as below sample
Hope this helps
Running monthly KPI_v10.5.twbx 18.3 KB
I need to digest it a bit but it works perfectly for my need. Thank you so much.