Forum Discussion
Filter a table using multiple values from an other table
Hello I have a table containing a lot of data. These data are catagorized by a RecordtypeID. I want to filter this table on 2 RecordTypeID. I would like to use the Recordtype table to filter the ...
Good day BenGi,
The List.Contains function may be used. Its first parameter is a list to search. Its second parameter is the value to search for.
If your first table is called “Table 1” then you can replace,
each( [RecordTypeId]=?????????? )
by
each List.Contains( #"Table1"[RecordTypeId], [RecordTypeId] )
#"Table 1"[RecordTypeId] is a list. It is the list of values in the "RecordTypeId" column of "Table 1" .
collinsg
Solution Sage
Solution SageGood day BenGi,
The List.Contains function may be used. Its first parameter is a list to search. Its second parameter is the value to search for.
If your first table is called “Table 1” then you can replace,
each( [RecordTypeId]=?????????? )
by
each List.Contains( #"Table1"[RecordTypeId], [RecordTypeId] )
#"Table 1"[RecordTypeId] is a list. It is the list of values in the "RecordTypeId" column of "Table 1" .