Forum Discussion
stefantaust
Helper I
Helper Ifilter across multiple columns
Hello, how can I filter the data and display all that contain an "X" and write the data in a new Table Regards Stefan
There are various methods.
Try this methods ...
In Power Query select the Check ID , Status and Bereich column
Then Transform > Unpivot > Unpivot Other columns
Then filter the rows that have "X"
Learn how here
https://learn.microsoft.com/en-us/power-query/unpivot-column
speedramps
Super User
Super UserYou could use a measure
Row has X =
// create a temp table of rows that have X is any of the 3 columns
var temptable =
FILTER('Table', 'Table'[Col1] = "X" || 'Table'[Col2] = "X" || 'Table'[Col3] = "X")
RETURN
// then return TRUE if the corresponding row has an item
NOT(ISEMPTY(myset))
//Then on your viual filter rows that are TRUE