Forum Discussion

EaglesTony's avatar
EaglesTony
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

How can I get a column duplicated based on a key

Hi,     I have this table:   Key          Status            Date 1              Review          null 1              In Progress    8/1/2024 1              Done             null   What I need...
Need Help
  • MNedix's avatar
    MNedix
    1 year ago

    I "brute-forced" it a bit, I hope it will work for you.

    IF(
   ISBLANK(
    CALCULATE(
        SELECTEDVALUE (Table1[Date]),
        ALLEXCEPT(Table1,Table1[Key]),Table1[Status]="InProgress")),BLANK(),
        CALCULATE(
        SELECTEDVALUE (Table1[Date]),
        ALLEXCEPT(Table1,Table1[Key]),NOT (ISBLANK(Table1[Date])),Table1[Status]="InProgress"))
EaglesTony's avatar
EaglesTony
Icon for Post Prodigy rankPost Prodigy
1 year ago

No,  because "

This should cover multiple scenarios where the date could be present in any of the 3 statuses." isn't what I want, just the "In Progress" status to be taken into account, if there is not "In Progress" (based on the Key), then it would be blank.

MNedix's avatar
MNedix
Icon for Solution Sage rankSolution Sage
1 year ago

I "brute-forced" it a bit, I hope it will work for you.

IF(
   ISBLANK(
    CALCULATE(
        SELECTEDVALUE (Table1[Date]),
        ALLEXCEPT(Table1,Table1[Key]),Table1[Status]="InProgress")),BLANK(),
        CALCULATE(
        SELECTEDVALUE (Table1[Date]),
        ALLEXCEPT(Table1,Table1[Key]),NOT (ISBLANK(Table1[Date])),Table1[Status]="InProgress"))
  • EaglesTony's avatar
    EaglesTony
    Icon for Post Prodigy rankPost Prodigy
    1 year ago

    Thanks this worked!