Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I would like to filter rows from a table based on a value in different columns. Here's an example of a table where I want to get the yellow column as extra column (or at least, the yellow column shows if the row must be in the selection);
So the column with the filter is based on a fiel value... Not shure if this is possible at all, maybe something like this:
= Table.SelectRows(#"Last Step", each [VALUE IN Filtercolumn] = [VALUE IN Filtervalue])
Thanx in advance!
Solved! Go to Solution.
Use below formula in a custom column
if Table.ColumnNames(Source){List.PositionOf(List.Range(Record.ToList(_),0,3), [Filtervalue])} = [Filtercolumn] then "Yes" else "No"
Use below formula in a custom column
if Table.ColumnNames(Source){List.PositionOf(List.Range(Record.ToList(_),0,3), [Filtervalue])} = [Filtercolumn] then "Yes" else "No"
Thanx! thanx! thanx a lot. Got it working now. Great!
Thanx fot your answer! I get the message that a value of type Record can't be converted to type Table (translated)... Value=[Record] Type=[Type].
I had to change Source to the right language.. sorry, but the result is now 'No' on each row.
Check out the July 2025 Power BI update to learn about new features.