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
I have a column with 6 different entries, contract 1, contract 2, contract 3, contract 4, contract 5, contract 6. How do you do a formula in a custom column to say if column says contract 1,2 or 3 put new contract in the custom column and if column says contract 4,5,6 put old contract,
many thanks
Solved! Go to Solution.
Case sensitive as follows
= if [column] = "contract 1" or [column] = "contract 2" or [column] = "contract 3" then "new" else "old"
Thanks Matt, I have followed that but get the below error
You seem to be missing a " after (Mantra)
Brilliant thanks for your help
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 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |