不使用MTD功能的MTD [英] MTD without using the MTD function

问题描述

这是我们当前的MTD计算:

  MEMBER [Time Calculations].[Time Calculations].[Calculate MTD] AS 
    Sum
    (
      MTD([Date].[Date - Calendar Month].CurrentMember)
     ,[Time Calculations].[Time Calculations].[Current Value]
    )

我已经看到使用范围运算符:的MTD计算过程中的某个地方.以下是从时间开始算起的总和:

I've seen somewhere along the way a MTD calculation that uses the range operator :. The following will be a sum from the start of time:

  MEMBER [Time Calculations].[Time Calculations].[Calculate MTD] AS 
    Sum
    (
      null: [Date].[Date - Calendar Month].CurrentMember
     ,[Time Calculations].[Time Calculations].[Current Value]
    ) 

谁能记住如何调整上述值，使其成为MTD计算?

Can anyone remember how to adjust the above so that it is a MTD calculation?

推荐答案

如果[Date - Calendar Month]与Adventure Works的Calendar层次结构相似，则以下内容可能对您有用:

If [Date - Calendar Month] is similar to Calendar hierarchy of Adventure Works, following might work for you:

  MEMBER [Time Calculations].[Time Calculations].[Calculate MTD] AS 
    Sum
    (
      [Date].[Date - Calendar Month].CurrentMember.firstsibling
       : 
      [Date].[Date - Calendar Month].CurrentMember
     ,[Time Calculations].[Time Calculations].[Current Value]
    ) 

这篇关于不使用MTD功能的MTD的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！