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 question:
I have 2 fields
Code - which contains - 6980
Cause - which contains - ABC
I'm looking to use Advanced Editor to populate the field Cause with value ZWR if Code = 6980
Thanks!
- Babinsky
Solved! Go to Solution.
There's probably some fancy M for that, but brute force, create a new conditional column,
= if [Code] = 6980 then "ZWR" else [Cause]
Remove your original Cause column and rename this column to Cause and done.
Hi Smoupre, for your suggestion below would this be a New Measure, New Column?
= if [Code] = 6980 then "ZWR" else [Cause]
Thanks!
- Babinsky
Thanks v-lvzhan-msft. That solution worked, sorry for the late reply as I was working on other assignments.
Have a great day everyone!
- Babinsky
Also, you can use the Add Conditional Column feature for that kind of calculations.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |