Forum Discussion
kasiaw29
Resolver II
Resolver IILOOKUPVALUE function with SEARCH that acts same as LIKE in SQL
Hi there,
Hopefully there is a simple solution for this. I'm using LOOKUPVALUE within a column, returning a date when found but I'm using Search as well as I only want it find part of a text and make a match.
In SQL it's a bit like this where text like '%search text%'
I have this so far
LOOKUPVALUE('Activivty History'[BASE_LINE_EARLY_START],'Activivty History'[BASELINE_REVISION_COMMENT],SEARCH("Layout",'Activivty History'[BASELINE_REVISION_COMMENT],,0))
But getting an error about mixes data types.
Thanks for any feedback!
Kasia
kasiaw29 , Try like
maxx(filter('Activivty History',SEARCH("Layout",'Activivty History'[BASELINE_REVISION_COMMENT],,0)>0),'Activivty History'[BASE_LINE_EARLY_START])
1 Reply
- amitchandak
Super User
kasiaw29 , Try like
maxx(filter('Activivty History',SEARCH("Layout",'Activivty History'[BASELINE_REVISION_COMMENT],,0)>0),'Activivty History'[BASE_LINE_EARLY_START])