Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
hi @humam85
try like:
Look Ahead Activity =
VAR _start = min('Updates'[Remaining Early Start])
RETURN
SWITCH(
TRUE(),
OR(
'Updates'[Start]>= _start
&&'Updates'[Start]<= _start + 40,
'Updates'[Finish]>= _start
&&'Updates'[Finish]<= _start + 40
),
"Yes",
"No"
)
hi @humam85
try like:
Look Ahead Activity =
VAR _start = DATE(2022,1,12)
RETURN
SWITCH(
TRUE(),
OR(
'Updates'[Start]>= _start
&&'Updates'[Start]<= _start + 40,
'Updates'[Finish]>= _start
&&'Updates'[Finish]<= _start + 40
),
"Yes",
"No"
)
hi @humam85
try like:
Look Ahead Activity =
VAR _start = min('Updates'[Remaining Early Start])
RETURN
SWITCH(
TRUE(),
OR(
'Updates'[Start]>= _start
&&'Updates'[Start]<= _start + 40,
'Updates'[Finish]>= _start
&&'Updates'[Finish]<= _start + 40
),
"Yes",
"No"
)
thanks for quick reply ...
it works well
if i want to put a specific date as 1/12/2022 rather than /min (remaining date)/
in wich format can i put it inside my dax
hi @humam85
try like:
Look Ahead Activity =
VAR _start = DATE(2022,1,12)
RETURN
SWITCH(
TRUE(),
OR(
'Updates'[Start]>= _start
&&'Updates'[Start]<= _start + 40,
'Updates'[Finish]>= _start
&&'Updates'[Finish]<= _start + 40
),
"Yes",
"No"
)
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |