Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
am_i_really
Frequent Visitor

Looking for measure or custom column similar to if else statement

Hi All, 

 

I'm looking for a measure or custom column that is similar to an if else statement. My column [Type] has a bunch of values that start with AE, what I need is that for any entry that starts with AE the result should be "AE", everything else should be "other". 

 

Table name: Table

Column name: Type

Text starts with AE: AE

All other entries: Other

 

Thanks in advance!

 

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

You can write a custom column in the query editor like this:

if Text.Start([Type], 2) = "AE" then "AE" else "Other"

The DAX calculated column equivalent would be

IF ( LEFT ( [Type], 2 ) = "AE", "AE", "Other" )

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

You can write a custom column in the query editor like this:

if Text.Start([Type], 2) = "AE" then "AE" else "Other"

The DAX calculated column equivalent would be

IF ( LEFT ( [Type], 2 ) = "AE", "AE", "Other" )

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors