Forum Discussion
path
Hello, i have one interesting question, i have a Path column(19 levels down) and SubPath column
Path Column, Sub-Parh Column
A/B/C B/C
A/B/D B/D
A/B/E B/E
I want to identify if Path column contains in it(at any level) a SubPath column's value, so in the middle of Path Column does the Sub-Path column's value exist?. Return true in case it contains it, else false. Tried with IF(CONTAINS, but it didn't work because it return only when you have the exact match between the 2 columns(for example if Path Column=A/B/C and the Sub-Path contains again A/B/C it works because they are exactly same, but if Sub-Path is on A/B it doesn't give me true). Can you help me please?
Hi Giavo,
Please try this formula:
Column = IF ( ISERROR ( FIND ( 'Path'[Sub-Path Column], 'Path'[Path Column] ) ), "False", "True" )
Best regards,
Yuliana Gu
3 Replies
Hi Giavo,
Please try this formula:
Column = IF ( ISERROR ( FIND ( 'Path'[Sub-Path Column], 'Path'[Path Column] ) ), "False", "True" )
Best regards,
Yuliana Gu
