Forum Discussion

Giavo's avatar
Giavo
Helper III
8 years ago
Solved

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 ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Giavo,

     

    Please try this formula:

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

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Giavo,

 

Please try this formula:

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

 

Best regards,
Yuliana Gu

  • Giavo's avatar
    Giavo
    Helper III
    8 years ago

    Thank you very much Yuliana, it worked :)

  • Giavo's avatar
    Giavo
    Helper III
    8 years ago

    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