I developed a suggested solution sheet in the attached file based on my understanding of your requirement. I have created a parameter which allows user to select measure. For current month, Today() is used and previous month is worked out based on it. However, you can create a parameter to define your current period.
Let me know if it works for you.
June vs. August 2.twbx 40.6 KB