Forum Discussion
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...
You will want to transform the data into a usable format using unpivot.
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.