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.
New to the Power BI world..
I am looking to create a new column that takes the value from another column if the column has a specific value.
Example:
If the home_station column has the name XYZ I would like my new column to return the value from the work_station. If the value is not XYZ, then I want to keep the value from from home_station. Please see example below
Solved! Go to Solution.
Thank you. Now, one question, if there are multiple values I want to change do I include "and,if" and if so how do I set that up? Been working on that and its not working
HI @sccoleman1189,
Maybe you can try to use 'in' operator to handle multiple values.
OR Condition= IF ( PBI_Report[HOME_STATION] IN { "XYZ", "MNO" }, PBI_Report[WORK_STATION], PBI_Report[HOME_STATION] ) AND Condition = IF ( PBI_Report[HOME_STATION] = "XYZ" && PBI_Report[BU] = "XXX", PBI_Report[WORK_STATION], PBI_Report[HOME_STATION] )
Reference links:
Regards,
Xiaoxin Sheng
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |