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 (In review) = BC

Open (Reviewed) = AW

Open (Submitted) = AW

Open (Waiting for Submission) = Sub

 

 

Thanks,

Pablo

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

4 Replies

  • 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

  • negi007's avatar
    negi007
    Community 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

     

  • robinHH's avatar
    robinHH
    Frequent Visitor
    5 years ago

    Hi Pablo,

    I am not sure if I got your question correct: You want to aggregate the different status e.g. Open (reviewed) and Open (Submitted) should be summarized as "AW"?

    If so, I would suggest to create a calculated column in DAX that uses the SWITCH-function (https://docs.microsoft.com/en-us/dax/switch-function-dax). 

    The formula could look like this:
    = SWITCH ( [Status_short], "Closed" = "AW", "Draft" = "AW" [...further expressions])

    Looking forward to see if I was able to help you!

    Cheers
    Robin