Since there is no dimension and you are looking at just the value of a specific month, you are able to look at the correct value... but since you are looking to get the whole month... you will need to Inter-Record Functions
What you need is to make sure that the MonthYear field is sorted in ascending order and then you can create Year in your Fact table itself without needing to create a bridge table...
