Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am making a new formula field. The field name is correct however it is saying that my field name is not recognized. What did I do wrong?
Solved! Go to Solution.
hi @nhodges
i just wanna repeat what tamerj1 said:
Make sure you are creating a calculated column in the correct table.
The closing bracket of IF should be after "No" not after "unsubmitted"
Hi, Still getting same error
I double checked an I am making it in the same table. And the workGroup field type is text. It is still showing the following
hi @nhodges
i just wanna repeat what tamerj1 said:
Make sure you are creating a calculated column in the correct table.
Yes, i think you are calculating a measure, so you should resume your column with some formula, maybe a SELECTEDVALUE before your name column would work.
If you create a calculated column you should not have problem, if you are calculating a measure you should try maybe:
IF(SELECTEDVALUE(Nametable[Nmaecolumn]) = X, Option1, Option2)
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |