Forum Discussion
Solved
Using filter in Query Editor especificing a cell from another table
Using filter in Query Editor with a value (text) from another table, especificing a cell from a column. code from Advanced Editor (I cleaned some parts to simplify): ... filter = (table1[col...
If I understand you correctly, you want to know how to get the first value from a table.
You can use Table.FirstValue, syntax:
Table.FirstValue(table as table, optional default as any) as any
If you supply a default value, then this value will be returned if the table is empty.
If I understand you correctly, you want to know how to get the first value from a table.
You can use Table.FirstValue, syntax:
Table.FirstValue(table as table, optional default as any) as any
If you supply a default value, then this value will be returned if the table is empty.
Im trying to filter table1[Group_Column] with a value from the first row and column of table2[Filter_Column]
Table1
| Group_Column | Description_Column |
| Group_A | Description1 |
| Group_A | Description2 |
| Group_B | Description3 |
| Group_A | Description4 |
Table2
| Filter_Column |
| Group_A |
and when I put the code:
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Group_Column] = Table2[Filter_Column]))
Came: 'This table is empty'