Forum Discussion

PabloGiraldo's avatar
PabloGiraldo
Icon for Helper IV rankHelper 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