Forum Discussion

Bpark1994's avatar
Bpark1994
Icon for Helper I rankHelper I
5 years ago

Need Dax Help Please!

Hi guys,   Here is my starting table im pulling into power bi:   User Task john 70 jim 70 john 71 john 30   I want to write a dax function called Qualified that says if a...
DAX
Desktop
POWER BI Dax rules
nandic's avatar
nandic
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Hi,
Could you try this formula:

Concatenax Value =
VAR Concat =
    CALCULATE (
        CONCATENATEX ( 'Table', 'Table'[Task], "," ),
        ALLEXCEPT ( 'Table', 'Table'[User] )
    )
RETURN
    IF (
        AND ( CONTAINSSTRING ( Concat, "70" ), CONTAINSSTRING ( Concat, 71 ) ),
        "Yes",
        "No"
    )



Attached demo file.

 

Regards,
Nemanja Andic