excel - 使用 DAX 寻找下一个工作日
问题描述
=IF(AND(WEEKDAY(AA3,2)<5,(AA3-INT(AA3))<17/24),((INT(AA3)+1)+12/24),IF(AND(WEEKDAY(AA3,2)<5,(AA3-INT(AA3))>17/24),((INT(AA3)+2)+12/24),IF(WEEKDAY(AA3,2)=5,(INT(AA3)+4)+12/24,IF(WEEKDAY(AA3,2)=7,(INT(AA3)+2)+12/24,IF(WEEKDAY(AA3,2)=6,(INT(AA3)+3)+12/24,)))))
我试图根据一周中的一天和一天中的小时找到下一个工作日。这是我已转换为 DAX 的内容,但它不起作用,我不知道为什么。
NBD =
IF (
AND (
WEEKDAY ( D2S[Actual Received Time], 2 <= 5 ),
HOUR ( D2S[Actual Received Time] ) < 14
),
(
INT ( D2S[Actual Received Time] ) + 23.99 / 24
),
IF (
AND (
WEEKDAY ( D2S[Actual Received Time], 2 ) = 5,
HOUR ( D2S[Actual Received Time] > 14 )
),
(
INT ( D2S[Actual Received Time] ) + 3 + 12 / 24
),
IF (
AND (
WEEKDAY ( D2S[Actual Received Time], 2 ) <= 5,
HOUR ( D2S[Actual Received Time] ) >= 14
),
INT ( D2S[Actual Received Time] ) + 1 + 12 / 24,
IF (
WEEKDAY ( D2S[Actual Received Time], 2 ) = 6,
INT ( D2S[Actual Received Time] ) + 2 + 12 / 24,
IF (
WEEKDAY ( D2S[Actual Received Time], 2 ) = 7,
INT ( D2S[Actual Received Time] ) + 1 + 12 / 24
)
)
)
)
)
解决方案
公式的第 4 行应为:
WEEKDAY ( D2S[Actual Received Time], 2 ) <= 5,
(括号外有“<= 5”)
推荐阅读
- c# - 读取 CSV 文件 - 面向对象的方式
- c++ - 错误消息:使用复制构造函数和重载赋值运算符
- android-studio - 找不到 appcompat.jar
- android - 如何使用 Python 从 Android 手机关闭 Windows 计算机
- python - Python Asyncio:如何等待某事?
- javascript - 如何只允许单个引导弹出元素
- vue.js - Vue使用来自JSON的数据显示模态点击
- python - 如何使 for 循环保持返回值?
- angular - Nativescript Run (iOS) 几乎不再工作了
- amazon-web-services - 生成的 Lambda 角色定义中的受信任实体是什么?