Forum Discussion

PabloGiraldo's avatar
PabloGiraldo
Helper IV
5 years ago
Solved

Create IF statement from column

Hi,   Trying to create a Ball in Court filter. I currently have a Status column with multiple statuses (i.e., closed, draft, open (in review), etc.)   If Status = Closed = AW Draft = AW Open (...
Need Help
  • timg's avatar
    timg
    5 years ago

    Hi Pablo,

     

    here's a reference formula based on test data. If you complete it with your case categories it should work. 

     

    TestColumn =
SWITCH (
    TRUE (),
    'Table'[Status] = "Expired", "AW",
    'Table'[Status] = "Open", "BC"
)

     

     

     

    Best regards,

    Tim

timg's avatar
timg
Solution Sage
5 years ago

Hi Pablo,

 

here's a reference formula based on test data. If you complete it with your case categories it should work. 

 

TestColumn =
SWITCH (
    TRUE (),
    'Table'[Status] = "Expired", "AW",
    'Table'[Status] = "Open", "BC"
)

 

 

 

Best regards,

Tim

  • PabloGiraldo's avatar
    PabloGiraldo
    Helper IV
    5 years ago

    Got it working. Thanks!