Forum Discussion
PowerQuery - Checking if Value in one column appears in a different columan
I am trying to create a column in power query when checking to see if the value in column 'C' resides in column 'B'. Example table below Column A Column B Column C New Column 1234 test 23...
wdx223_Daniel
Community Champion
Community Champion=let a=List.Buffer(TableName[ColumnA]) in Table.AddColumn(TableName,"NewColumn",each if List.Contains(a,[ColumnC] then [ColumnC] else null)