Hi,
I have a dataset named "AllData". It has a column named as "ObjectID". I want a filtered table basis the criteria that values in ObjectID column contains a value string "SearchString".
The formula syntax for filter function is FilteredDataTable = FILTER(AllData,AllData[ObjectId]="SearchString") but it doesn't help because it just returns data by filtering values which are exactly equal to "SearchString". Whereas I want to get filtered data table which contains "SearchString" in it.
Please help.
Thanks,
DJ
I have a dataset named "AllData". It has a column named as "ObjectID". I want a filtered table basis the criteria that values in ObjectID column contains a value string "SearchString".
The formula syntax for filter function is FilteredDataTable = FILTER(AllData,AllData[ObjectId]="SearchString") but it doesn't help because it just returns data by filtering values which are exactly equal to "SearchString". Whereas I want to get filtered data table which contains "SearchString" in it.
Please help.
Thanks,
DJ