• This is a common problem. You need a composite key for the MonthName. Add the year as well, so that you get April 2016 instead of just April.

    The reason for this is that if you just use the month, SSAS has no idea to which year it belongs.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP