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

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