Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax

Hello All, 

I have a table with text and project name 

textproject name
Completed S_enter
In-progressS_enter
AcceptedS_enter
released to ProdS_enter
being groomedS_enter
definedS_enter
nullM_Pay
definedT_Core
AcceptedT_Core

 

i have to create a Dax
Conditions are as below
if the project has any one the these text column values (Completed , in progress and released to prod ) then we have to keep  it as Yes or else No
so my output should look like

textproject name
YESS_enter
NOT_Core
YESM_Pay
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 

    you can slice by project name and use

    Check =
IF (
    ISEMPTY (
        INTERSECT (
            VALUES ( TableName[text] ),
            { "Completed", "in progress", "released to prod" }
        )
    ),
    "No",
    "Yes"
)

     

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Anonymous 

    you can slice by project name and use

    Check =
IF (
    ISEMPTY (
        INTERSECT (
            VALUES ( TableName[text] ),
            { "Completed", "in progress", "released to prod" }
        )
    ),
    "No",
    "Yes"
)