powerbi - 查找两个日期之间的差异，不包括非工作日

Question

需要两个日期之间的天数，不包括非工作日。

一些定义

Sales[date1]
Sales[date2]

DeterminesWeekDay = WEEKDAY(Payment[Deposit Date],3) 


Weekend -Weekday = 
SWITCH(TRUE(),
    Sales[DeterminesWeekDay] = 0, "Weekday",
    Sales[DeterminesWeekDay] = 1, "Weekday",
    Sales[DeterminesWeekDay] = 2, "Weekday",
    Sales[DeterminesWeekDay] = 3, "Weekday",
    Sales[DeterminesWeekDay] = 4, "Weekday",
    Sales[DeterminesWeekDay] = 5, "Weekend",
    Sales[DeterminesWeekDay] = 6, "Weekend",
    BLANK()
)

我坚持使用我的 dax 功能，制作新的度量或列。

WorkDaysOnly = 
CALCULATE(DATEDIFF(MIN(Sales[date1]),MIN(Sales[date2]),DAY),
        FILTER(Sales, Sales[Weekend -Weekday] = "Weekday") )

这里我不知道如何选择我的两个日期之间的差异，它仍然计算周末。

例如，date1 = 6/7/2019 和 date2 =6/10/2019，我期待的是一天而不是 3。最好复制我的日期列并删除所有周末日期，如何？

标签： powerbidax

Answer 1

请创建以下措施

No of working days = CALCULATE(SUM('calendar'[isWroking]),DATESBETWEEN('calendar'[Date],Sales[Date 1],Sales[Date 2]))


   isWroking = IF(WEEKDAY('calendar'[Date],2)<=5,1,0)

**注意 isWorking 应该在日历表中创建