Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nhodges
Helper I
Helper I

Not recognizing my field in my formula

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?

nhodges_0-1674663299070.png

 

nhodges_1-1674663410221.png

 

1 ACCEPTED SOLUTION

hi @nhodges 

 

i just wanna repeat what tamerj1 said:

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

 

FreemanZ_0-1674689616866.png

 

View solution in original post

6 REPLIES 6
tamerj1
Super User
Super User

@nhodges 

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

Hi, Still getting same error

nhodges_0-1674670860425.png

 

@nhodges 

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

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

nhodges_0-1674683297068.png

 

hi @nhodges 

 

i just wanna repeat what tamerj1 said:

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

 

FreemanZ_0-1674689616866.png

 

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)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors