Forum Discussion
getting unexpected errors
a minute ago Afternoon all, hope you can help out. I am tring to compare two text fields in a column on two different tables and then return a text field value and write it in a column o...
mikeST DISTINCT returns a table and you can't return a table as a column or measure result. I'm not sure but I *think* you want something like this:
New Column in Table1 =
VAR __ID = [SYSTEM_ID]
VAR __UIC = [UIC]
VAR __OtherUIC = MAXX( FILTER( 'Table2', [SYSTEM_ID] = __ID ), [UIC] )
VAR __Result = IF( __UIC = __OtherUIC, __OtherUIC, BLANK() )
RETURN
__Result