Forum Discussion
If Text Contains Statement
Hi Dane ,
Does this one here work for you?
IF ( SEARCH ( "2L", OrderDetails[PartNumber], 1, BLANK() ), TrackingHistory[Width] *2, ( TrackingHistory[Width] *2 ) + ( TrackingHistory[Height] *2 ) )
I pressumed that your logical test shall search for "2L" in PartNumber, meaning "2L" could come up at different positions in a string (i.e. "ABC 2L", "2L DEF", "GHI 2L JKL" etc.).Let me know if this helps and if not, feel free to share some sample data and I can take a deeper look into it 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hi Dane ,
Does this one here work for you?
IF (
SEARCH (
"2L",
OrderDetails[PartNumber],
1,
BLANK()
),
TrackingHistory[Width] *2,
( TrackingHistory[Width] *2 ) + ( TrackingHistory[Height] *2 )
)
I pressumed that your logical test shall search for "2L" in PartNumber, meaning "2L" could come up at different positions in a string (i.e. "ABC 2L", "2L DEF", "GHI 2L JKL" etc.).
Let me know if this helps and if not, feel free to share some sample data and I can take a deeper look into it 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
I tried your solution but could not bring in OrderDetails[PartNo] into the formula for some inexplicable reason. Can I email you the PBIX I have?
- Hi Dane,
I'd suggest that you upload your pbix file to a sharepoint or public dropbox folder and paste the link into the forum. With that others will be able to help you, too!
Alternatively, you could just paste a few rows of your two tables OrderDetails and TrackingHistory. Make sure to explain their connection as well
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/