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.
It works, using this:
= Table.SelectRows(#"Changed Type", each ([Group_Column] = Table.FirstValue(Table2)))
ty MarcelBeug.
att,
Alexandre.