Forum Discussion
Need help with this logic
Hello Everyone, I am trying to create logic but failed to do. I need to create a Status Column. In which there should be rows/options i.e "On-Time", "Late", "Released" "On-Time"= NOT(ISBLANK(Pr...
Hi,
Try the following DAX:
If this answer help you, please make it as solution.
Status =
IF(
NOT(ISBLANK(Project_v2_w_LW_PPC[Release Date])) &&
Project_v2_w_LW_PPC[Release Date] <= Project_v2_w_LW_PPC[Baseline_EndDate],
"On-Time",
IF(
NOT(ISBLANK(Project_v2_w_LW_PPC[Release Date])) &&
Project_v2_w_LW_PPC[Release Date] > Project_v2_w_LW_PPC[Baseline_EndDate],
"Late",
IF(
ISBLANK(Project_v2_w_LW_PPC[Release Date]) &&
Project_v2_w_LW_PPC[Baseline_EndDate] < TODAY(),
"Late",
IF(
NOT(ISBLANK(Project_v2_w_LW_PPC[Release Date])),
"Released",
BLANK()
)
)
)
)
Hello @Bibiano_Geraldo Thank you for your response. After using your DAX I am only getting On-Time and Late.