Forum Discussion
Helper IIINeed help with this logic
Helper IIIHello 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.
Super UserHi,
Based on your table, you need to create two calculated columns and you will have to add two slicers to your report:
Column for released status:
ReleasedStatus =
IF(
NOT(ISBLANK(Project_v2_w_LW_PPC[Release Date])),
"Released",
BLANK()
)
Column for On time and Late Status:
OnTimeOrLate =
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]),
"Open",
BLANK()
)
)
)