Forum Discussion
Solved
Combining and merging fields on same table?
Hi there, I searched but couldn't find anything relating to this. Hope someone could please help: I have a table with and ID field and numerous fields for various Rules with a 1 or null (1 if the...
Use Power Query. I suggest selecting all the Rule columns and replace null with 0.
Then , again with all rule columns selected, choose 'Unpivot' from the transform menu.
That will give 3 columns ID, Attribute, Value. You can rename if required.
Pull ID and Attribute on to a table visual (and Value if required). Use the filter pane to select Value = 1 for rule violations.
