Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!
Solved! Go to Solution.
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" )
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" )
User | Count |
---|---|
19 | |
10 | |
10 | |
9 | |
7 |