Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Hi @Giavo,
Please try this formula:
Column = IF ( ISERROR ( FIND ( 'Path'[Sub-Path Column], 'Path'[Path Column] ) ), "False", "True" )
Best regards,
Yuliana Gu
Hi @Giavo,
Please try this formula:
Column = IF ( ISERROR ( FIND ( 'Path'[Sub-Path Column], 'Path'[Path Column] ) ), "False", "True" )
Best regards,
Yuliana Gu
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
Thank you very much Yuliana, it worked 🙂
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |