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 all,
I have a 'Name' column that contains duplicate values. I'd like a new column that either says "Kitchen" or "Utililty" based on the value in the qty column. The higher number should say "Kitchen", and the lower "Utility".
Name | Qty | Custom Column |
ABC | 10 | Utility |
XYZ | 30 | Kitchen |
XYZ | 15 | Utility |
ABC | 27 | Kitchen |
The name column will only ever have 2 of the same entry, never more. So one will always say "Kitchen" and one will always say "Utility", based on the qty column.
Can anyone help me achieve this please?
Many thanks
Solved! Go to Solution.
Hi @Lee5150
I have one quick question so name alway will only two qty or more than that? as per the give data i have created the custom column
You can achive this by create custom colum measure
Here is my another example hope your all case is covered in this
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Regards
@Lee5150
I hope this caluculation will help u to Yours requirements .Better U can use this calculation I'm getting similar output what u required.
Thanks ,
Thennarasu
Did I answer your Question? Mark Accepted as a solution .
Thank you very much!
Hi @Lee5150
I have one quick question so name alway will only two qty or more than that? as per the give data i have created the custom column
You can achive this by create custom colum measure
Here is my another example hope your all case is covered in this
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Regards
This works perfectly! Thank you so much
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 |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |