cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

categorical data scenario dax query

Hi folks,

I hope you all are doing well and at your best health.

I have a doubt in a scenario based question. I have a categorical data - with 8 different categories. I want to flag these categories as 1,2,...8.
I was thinking about using if condition but I need to write if condition 8 times. Is there a better way of doing it? Thanks in advance!

2 ACCEPTED SOLUTIONS
Community Champion

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.

Community Champion

@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.

5 REPLIES 5

Thanks @truptis ! it worked!

Community Champion

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.

Thanks for your quick response @truptis . Is it possible for you to help me writing the measure?
i have a field -Category and within that field i have A, B, C, D, E, F,G & H and I want to number them as 1,2...8 and if no letter is there then mark it as 0.

Post Patron

MEASURE = SWITCH(TRUE(),
A=?, 1,
B=?, 2,

C=?, 3,

D=?, 4,

BLANK()

)

OR
MEASURE =
IF(A),1,
IF(B),2,

IF(C),3,

IF(D),4,
BLANK()
))))

Community Champion

@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.

Announcements

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors