Solved: im need search values to started with text

Anonymous · ‎03-06-2023

Good morning.

Im need search anythigs values to started within text "14" or "15", please.

thanks!

Fowmy · ‎03-06-2023

@Anonymous

Create a measure:

Result =
IF (
    CONTAINSSTRING ( SELECTEDVALUE ( tablename[CODIGO] ), "14" )
        || CONTAINSSTRING ( SELECTEDVALUE ( tablename[CODIGO] ), "15" ),
    "Found"
)

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

View solution in original post

Fowmy · ‎03-06-2023

@Anonymous

Create a measure:

Result =
IF (
    CONTAINSSTRING ( SELECTEDVALUE ( tablename[CODIGO] ), "14" )
        || CONTAINSSTRING ( SELECTEDVALUE ( tablename[CODIGO] ), "15" ),
    "Found"
)

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group