两个日期之间的工作日差异 [英] Difference in work days between two dates

问题描述

我正在尝试创建一个计算列，以根据工作日指导表计算两个日期之间的工作日差异.

I am trying to create a calculated column to calculate the difference in work days between two dates based on a work day steering table.

在工作日指导表中，银行工作日标记为 0，工作日标记为 1.

In the work day steering table, the bank days are flagged as 0 and work days as 1.

我应该使用什么 DAX 公式来创建计算列来获取两个日期之间的工作日差异?

What DAX formula should I use to create a calculated column to get the difference in work days between two dates?

预期结果为黄色:

Expected Result in yellow:

工作日指导表:

Work day steering table:

推荐答案

可以统计BankDay = 1的日期.

WorkDays_CalculatedColumn =
COUNTROWS (
    FILTER (
        WorkDaySteering,
        WorkDaySteering[BankDay] = 1
            && WorkDaySteering[Date] > Input[Ship Date]
            && WorkDaySteering[Date] <= Input[Delivery Date]
    )
)

这篇关于两个日期之间的工作日差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！