Create IF statement from column

[PabloGiraldo]

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

[robinHH]

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

[negi007]

@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

[timg · Accepted solution]

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]

Got it working. Thanks!