Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
77 | |
76 | |
70 | |
49 | |
42 |
User | Count |
---|---|
62 | |
40 | |
32 | |
30 | |
29 |