Average Monthly calculations
You'll often be tempted to build a CASE WHEN Level calc to get an average monthly calc, but there's an better way.
You'll notice the error when using CURRENTMember and in the client tool doing a multi-select, it doesn't work because it doesn't have a single member to work against - this solution fixes this
Read more...Tags: mdx