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

negi007's avatar
negi007
Icon for Community Champion rankCommunity Champion
5 years ago

PabloGiraldo  I guess you are trying create three groups basis the status. I would suggest you to use the group function. Right click on the status column and select new group

 

 

then you can create three groups for your values and you can use it instead of values of status column. I hope it helps you