Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |