Comparing Multiple Columns with a single measure or calculated column?
Hi all - I'm comparing two categories for differences but each category has multiple columns (i.e. category 1 (current columns) has 82 columns vs category 2 (first columns) has 82 columns as well). I'd like to know the difference per each columns recording only the data under category 2 if there's a difference.
All of the data has a first and current version column in the dataset. I am trying to compare multiple columns to see if the same value is there in the "current" version column or if another value is in one of the "first" columns. For example in the table below, I'm looking to determine which of the values have been added/removed or stayed the same between the current and first version columns.