topic Re: Not recognizing my field in my formula in DAX Commands and Tips

Not recognizing my field in my formula

nhodges — Wed, 25 Jan 2023 16:17:20 GMT

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?

Re: Not recognizing my field in my formula

tamerj1 — Wed, 25 Jan 2023 16:42:21 GMT

nhodges

The closing bracket of IF should be after "No" not after "unsubmitted"

Re: Not recognizing my field in my formula

nhodges — Wed, 25 Jan 2023 18:21:15 GMT

Hi, Still getting same error

Re: Not recognizing my field in my formula

tamerj1 — Wed, 25 Jan 2023 18:54:55 GMT

nhodges

Make sure you are creating a calculated column in the correct table

Re: Not recognizing my field in my formula

nhodges — Wed, 25 Jan 2023 21:48:27 GMT

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

Re: Not recognizing my field in my formula

FreemanZ — Wed, 25 Jan 2023 23:34:06 GMT

hi nhodges

i just wanna repeat what tamerj1 said:

Make sure you are creating a calculated column in the correct table.

Re: Not recognizing my field in my formula

Wheezy — Wed, 25 Jan 2023 23:39:53 GMT

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)