cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Udt_KV
Post Partisan
Post Partisan

DAX IF text contains

Hi Team,

 

I have Markets and i need output in status column,

 

DAX - if markets contains 40* then H else W

 

Pleas 

 

Capture1.PNG

Thanks,

KV's

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @Udt_KV ,

 

you should be able to solve that with a calculated column and the function CONTAINSSTRING:

Status = IF( CONTAINSSTRING( myTable[Markets], "40" ), "H", "W" )

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

5 REPLIES 5
MdJ83
Helper II
Helper II

Can you make this with multiple items for example by adding in || althouhg I get and error saying cannot convert value of type text to type true and false

Status = IF( CONTAINSSTRING( myTable[Markets], "40"||"50" ), "H", "W" )

 

selimovd
Super User
Super User

Hey @Udt_KV ,

 

you should be able to solve that with a calculated column and the function CONTAINSSTRING:

Status = IF( CONTAINSSTRING( myTable[Markets], "40" ), "H", "W" )

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Hey @selimovd 

Your response here really helped me, thank you!

 

I need to add an AND statement, but it's not working. Can you advise me please?

 

It would look something like this 

IF (CONTAINS STRING (Table Y [Column], "A"), AND CONTAINS STRING (Table X [Column], "A"), "B",  "C")

 

Thank you!

 

  

Hey @Carrhill ,

 

sure, you can combine them with the AND function:

Status =
IF (
    AND (
        CONTAINSSTRING ( 'Table Y'[Column], "A" ),
        CONTAINSSTRING ( 'Table X'[Column], "A" )
    ),
    "B",
    "C"
)

 

Or you can combine them with two &&:

Status =
IF (
    CONTAINSSTRING ( 'Table Y'[Column], "A" ) && CONTAINSSTRING ( 'Table X'[Column], "A" ),
    "B",
    "C"
)

 

Both should work the same way.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

Hey @Udt_KV ,

 

did it work with the calculated column I proposed?

I'm curious if you could solve this issue 🙂

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.