path

[Giavo]

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?

[v-yulgu-msft · Accepted solution]

Hi @Giavo,

Please try this formula:

Column =
IF (
    ISERROR ( FIND ( 'Path'[Sub-Path Column], 'Path'[Path Column] ) ),
    "False",
    "True"
)

Best regards,
Yuliana Gu

[Giavo]

Do you think that it is possible in Power BI to Highlight or put in Evidence some how the Sub-Path part inside the Path column ? So if TRUE then i would like that part be highlighted inside Path

[Giavo]

Thank you very much Yuliana, it worked 🙂