主页 / coding / 问题 / 78548113
Accepted
Seyma Kalay
Asked: 2024-05-29 15:58:30 +0800 CST

如何计算 DAX 中最新可用的本周

  • 772

下面的代码计算Current Week Amt最新Fiscal Week num = 52可用的。但它无法Fiscal Week num根据Source File.

 Current Week Amt = 
    VAR CurrentFiscalWeek = MAX( 'DF'[Fiscal Week num] )
    RETURN
    CALCULATE(
         [total Measure],
        'DF'[Fiscal Week num] = CurrentFiscalWeek
    )

我有一个不同的数据集Fiscal Week num。我想考虑最新的Fiscal Week num52、49 和 48。有没有办法在代码中利用它？提前谢谢了

Source Files   Fiscal Week num
Company A       52
Company B       49
Company C       48
dax

1 个回答

  1. Best Answer

    如果没有有关数据集的更多信息，很难给出答案，但是，请尝试以下操作：

    Latest Week Amt = 
  var latestFiscalWeek =
    CALCULATE(
      MAX('DF'[Fiscal Week num]),
      REMOVEFILTERS('DF'[Fiscal Week num])
    )
  RETURN
    CALCULATE(
      [total Measure],
      REMOVEFILTERS('DF'[Fiscal Week num]),
      'DF'[Fiscal Week num] = latestFiscalWeek
    )
    • 1

相关问题