DAX 中的项目收入计算

我需要计算项目安装+维护的持续收入，并计算 Power BI 中 DAX 中用于控制目的的月收入。

问题如下。

这些项目存储在一个表 CONTRACTS 中，如下所示：

我有一个单独的日期表 INST_DATE_TABLE：

这些表通过 [INSTALLATION_DATE] 字段连接。

每个月的收入是 [INSTALLATION_REVENUE] 的总和（如果安装是在该月进行的）加上从第一个月开始的每月维护收入，即 [MAINTENANCE_COST_PER_UNIT] * [MAINTENANCE_UNIT] / 12。

And the maintenance revenue should be only calculated if the current date is beyond the installation date!

Some contracts are not yet signed, so they dont't have an installation date set (NULL)

So the INSTALLATION REVENUE DAX is like this:

    .INSTALLATION_REVENUE = 
     CALCULATE (
        SUMX(CONTRACTS; 
        CONTRACTS[INSTALLATION_REVENUE] 
            );
        CONTRACTS[INSTALLATION_DATE] > 0
     )

And the MONTHLY REGULAR REVENUE is like this:

    .REGULAR_REVENUE = 
    CALCULATE ( 
       SUMX(CONTRACTS; 
       CONTRACTS[MAINTENANCE_COST_PER_UNIT]*CONTRACTS[MAINTENANCE_UNIT]
        ) / 12;
        CONTRACTS[INSTALLATION_DATE] > 0
     )

For all dates I can calculate the cash flow of the latter like this:

     .REGULAR_REVENUE_ONGOING = 
      CALCULATE ( 
          [.REGULAR_REVENUE];
          ALL(INST_DATE_TABLE[INSTALLATION_DATE])
      )

which gives me a nice series of monthly revenues for all periods. But I only would like to see this for the periods that are beyond the installation date!

So lets say filtered on contract 1 I have now the following cash flow:

But for periods before 2019.04.01 I would like to see zeros!

How can I do that?

I just can't filter on dates referring to the installation date of the project!

在我获得一份合同的预期结果后，很容易对所有这样的合同进行总结

      .TOTAL_REVENUE = 
      [.INSTALLATION_REVENUE] + [.REGULAR_REVENUE_EXPECTED]

更新：

我创建了一个累计总数来显示持续收入，如下所示：

   .REGULAR_REVENUE_ONGOING = 
   CALCULATE ( 
       [.REGULAR_REVENUE];
       FILTER(
           ALL(INST_DATE_TABLE[INSTALLATION_DATE]);
           INST_DATE_TABLE[INSTALLATION_DATE
             <=MAX(INST_DATE_TABLE[INSTALLATION_DATE])
           )
     )

这显示了正确的系列，但现在我有另一个问题。当我尝试累积这个已经累积的数据系列时，它不会累积为累积数据系列！

任何帮助，将不胜感激

   .REVENUE_TOTAL_CUMULATIVE = 
    CALCULATE(
       [.REVENUE_TOTAL];
       FILTER(
           INST_DATE_TABLE;
           INST_DATE_TABLE[INSTALLATION_DATE] <= MAX(INST_DATE_TABLE[INSTALLATION_DATE])
           )
    )