我有这些数据
StartDate ,EndDate
03/01/2022, 06/01/2022
09/01/2022, 24/01/2022
20/01/2022, 27/01/2022
10/01/2022,22/01/2022
03/01/2022, 17/01/2022
28/01/2022, 20/01/2022
22/01/2022, 18/01/2022
28/01/2022, 05/01/2022
06/01/2022, 30/01/2022
10/01/2022, 18/01/2022
20/01/2022, 14/01/2022
12/01/2022, 11/01/2022
23/01/2022, 01/01/2022
09/01/2022, 06/01/2022我想将Endate列格式化如下
IF StartDate > EndDate THEN Blue else green预期产出

发布于 2022-10-05 18:30:47
制定一项措施:
Measure = IF(MAX(Table1[StartDate]) > MAX(Table1[EndDate]),1)转到单元格元素以确定结束日期。

完成如下:


https://stackoverflow.com/questions/73964545
复制相似问题