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"=
"Late"=
"Released"=
(Basically, if any row has a Release Date Then It will be considered as Released)
The issue is with the Released logic because of overlapping conditions with On-Time and Late. How to write this codition correctly?
Thank You,
Ajit
19 Replies
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.
Hello Bibiano_Geraldo Thank you for your response. After using your DAX I am only getting On-Time and Late.
Could you please share a sample of your table? Please dont share sensitive data.
Note: The released status will only appear if all other status are not satisfied.Hello Bibiano_Geraldo and Uzi2019 My data looks like this. I want to create a visual table like this and add a status slicer. From that slicer, If I select On-Time then it should show On-Time rows and For Late selection it should show Late and For Released Selection, it should show those rows which have a release date.
Can you share the sample data with expected output??
It would be better working with data instead of just a logic.
you can share the simple excel file screenshot for better understanding.
Project Number Activity Number Task Name Resource Baseline EndDate Release Date 226 3000 Long Lead Release MECHANICAL 8/16/2024 0:00 8/16/2024 0:00 227 3000 Long Lead Release MECHANICAL 8/16/2024 0:00 8/16/2024 0:00 100 3000 Manuals Complete TECH 6/18/2024 0:00 6/18/2024 0:00 227 3001 GA Tasks/Initial BOM MECHANICAL 9/13/2024 0:00 9/20/2024 0:00 225 3002 GA Initial BOM Release MECHANICAL 7/29/2024 0:00 8/16/2024 0:00 226 3002 BOM Release MECHANICAL 9/13/2024 0:00 220 3002 Initial BOM MECHANICAL 2/29/2024 0:00 3/29/2024 0:00 72 3002 l Comp Long Lead MECHANICAL 5/31/2024 0:00 5/10/2024 0:00 131 3002 Paint Scheme MECHANICAL 6/21/2024 0:00 5/2/2024 0:00 131 3003 Stop Kit ELECTRICAL 5/31/2024 0:00 5/31/2024 0:00 225 3003 MA Group MECHANICAL 9/17/2024 0:00 132 3004 Power Revision ELECTRICAL 7/29/2024 0:00 7/30/2024 0:00 My data looks like this. I want to create a visual table like this and add a status slicer. From that slicer, If I select On-Time then it should show On-Time rows and For Late selection it should show Late and For Released Selection, it should show those rows which have a release date
My data looks like this. I want to create a visual table like this and add a status slicer. From that slicer, If I select On-Time then it should show On-Time rows and For Late selection it should show Late and For Released Selection, it should show those rows which have a release date
Hello Uzi2019
My data looks like this. I want to create a visual table like this and add a status slicer. From that slicer, If I select On-Time then it should show On-Time rows and For Late selection it should show Late and For Released Selection, it should show those rows which have a release date.
Can you add one more staus column of Late/Release/On time. next to your table.???
so that will create logic accordingly..
Hello Bibiano_Geraldo and Uzi2019
My data looks like this. I want to create a visual table like this and add a status slicer. From that slicer, If I select On-Time then it should show On-Time rows and For Late selection it should show Late and For Released Selection, it should show those rows which have a release date
ajitsahoo8338 You can try:
Status =
SWITCH(
TRUE(),
NOT(ISBLANK(Project_v2_w_LW_PPC[Release Date])), "Released",
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",
(
ISBLANK(Project_v2_w_LW_PPC[Release Date]) && Project_v2_w_LW_PPC[Baseline_EndDate] < TODAY()
) ||
(
NOT(ISBLANK(Project_v2_w_LW_PPC[Release Date])) && Project_v2_w_LW_PPC[Release Date] > Project_v2_w_LW_PPC[Baseline_EndDate]
), "Late",
BLANK()
)This structure ensures each row fits into exactly one category without overlap.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedInHello Kedar_Pande This is not working
