Forum Discussion
Calculated Column (only getting measures)
I am trying to create a claculated column where I combine two columns in my Equipment table. However the only columns it will recognize from this table are measures that I built. (And when I start typing "Equipment" its only autofill suggestions are the measures from this table.)
Any help is appreciated.
Z
Hey,
it depends on your formular, can you show your wanted result?
it is also not important what is suggested by autofill. You can refer the column like
Table[Field]
or if it is in the same table just with fieldname
Greetings.
3 Replies
- Greg_DecklerCommunity Champion
Are you creating the calculated column in your Equipment table or some other table? If some other table, you may have to use RELATED or RELATEDTABLE or LOOKUPVALUE.
- WolfBiberMicrosoft Employee
Hey,
it depends on your formular, can you show your wanted result?
it is also not important what is suggested by autofill. You can refer the column like
Table[Field]
or if it is in the same table just with fieldname
Greetings.
- v-jiascu-msftMicrosoft Employee
Hi Anonymous,
Please also confirm it's a calculated column, not a measure by accident.
Best Regards,
Dale