cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
karma
Advocate II
Advocate II

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
truptis
Community Champion
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.

View solution in original post

truptis
Community Champion
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.

View solution in original post

5 REPLIES 5
karma
Advocate II
Advocate II

 Thanks @truptis ! it worked! 

truptis
Community Champion
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.

simply follow this :

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()
))))

truptis
Community Champion
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.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

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

Power BI Fabric Summit Carousel

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