Forum Discussion

Uzi2019's avatar
Uzi2019
Community Champion
1 year ago

HI ajitsahoo8338 

 

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.

 

 

ajitsahoo8338's avatar
ajitsahoo8338
Helper III
1 year ago

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.

 

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    1 year ago

    Hi ajitsahoo8338 

     

    Can you add one more staus column of Late/Release/On time. next to your table.???

    so that will create logic accordingly..

     

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    Hi,
    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()
    )
    )
    )