Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All
I have field name BRAND_5 , it have 4 value lable , for example :-
3.0
3M
400A
4MM
I have below expression :-
3M
400A
4MM
May i know how to make it return :-
3M
Paul Yeo
Solved! Go to Solution.
@admin11 If you want to add a new column, try this:
BRAND_F =
Var _A =
SUBSTITUTE(
SUBSTITUTE('SALES_T'[BRAND_5],
"3M","3M"),
"3.0","3M")
return
if(_A="3M",_A,blank())
output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
HI @admin11
It already returend 3M, can you add more details about your expected output?
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
@admin11 If you want to add a new column, try this:
BRAND_F =
Var _A =
SUBSTITUTE(
SUBSTITUTE('SALES_T'[BRAND_5],
"3M","3M"),
"3.0","3M")
return
if(_A="3M",_A,blank())
output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
wHEN i try to apply the expression to my actual PBI file , i get error , i cannot figure out where i go wrong , by looking at the error code. in case you have any hint , do share with me.
Today i try to copy your orginal code to my actual power PBI file , and from there i slowly modify the
- 3M to UR
- 3M to UNIVERSAL
no error now
Thank
Do you want it as a column, table or measure? how do you want to use it?
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
87 | |
49 | |
45 | |
38 | |
37 |