Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
I would like to create a new column to group my customer base on certain rules. Please take a look at the example I created below
Customer | Item Purchased |
AAA | GT |
BBB | GT |
AAA | AT |
CCC | AT |
CCC | FT |
DDD | GT |
DDD | GT |
AAA | HT |
CCC | HT |
I want the rule to be like this:
New column= if customer = AAA = "AAA",
if customer = BBB = "BBB"
anything else will be grouped as "others"
Can anyone tell me how to set this formula?
Let me know if my request is confusing.
Thanks!
Solved! Go to Solution.
Hi, @Yuiitsu
Based on your description, you may create a meausre or a column as follows.
Result =
var _customer = SELECTEDVALUE('Table'[Customer])
return
IF(
ISFILTERED('Table'[Customer]),
IF(
_customer in {"AAA","BBB"},
_customer,
"others"
)
)
Result Column =
IF(
'Table'[Customer] in {"AAA","BBB"},
'Table'[Customer],
"others"
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Yuiitsu
Based on your description, you may create a meausre or a column as follows.
Result =
var _customer = SELECTEDVALUE('Table'[Customer])
return
IF(
ISFILTERED('Table'[Customer]),
IF(
_customer in {"AAA","BBB"},
_customer,
"others"
)
)
Result Column =
IF(
'Table'[Customer] in {"AAA","BBB"},
'Table'[Customer],
"others"
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Experts
I found out that I could just right click the column and add new group.
It is so much easier!
Thanks alot for all the info guys!
Try a new column
New column = switch( true(),
[customer] = "AAA", "AAA",
[customer] = "BBB", "BBB",
"Others"
)
Also check : https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |