categorical data scenario dax query

Hi karma ,

If you don't wish to go with IF condition then you can try SWITCH() in dax. Below is the link for the same.

https://docs.microsoft.com/en-us/dax/switch-function-dax

Please hit the thumbs up & mark it as a solution if this helps you. Thanks.

karma -> try this:

Result = SWITCH([COLUMNNAME], "A", 1, "B", 2, "C",3, "D",4,"E",5,"F",6,"G",7,"H",8, 0)

Please hit the thumbs up & mark it as a solution if it helps you. Thanks.