Forum Discussion
Using filter in Query Editor especificing a cell from another table
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'
It works, using this:
= Table.SelectRows(#"Changed Type", each ([Group_Column] = Table.FirstValue(Table2)))
ty MarcelBeug.
att,
Alexandre.
