Forum Discussion

taskinosurname's avatar
taskinosurname
Frequent Visitor
3 years ago
Solved

Return "Yes" or "No" based on Multiple Conditions

Hi Everyone,   I'm working on a collision dashboard/report where it would identify whether a driver requires retraining or not. The measure would return a value of "Yes" or "No" based on certain co...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, taskinosurname 

     

    You can try the following methods.
    Sample data:

    Measure:

    Difference = IF(SELECTEDVALUE('Table'[Last Collision Date])=BLANK(),0,
ABS (DATEDIFF (SELECTEDVALUE ( 'Table'[Date] ),
              SELECTEDVALUE ( 'Table'[Last Collision Date] ),MONTH)))
    Retraining Req'd = 
IF (SELECTEDVALUE ( 'Table'[Last Collision Date] ) <> BLANK ()
        && SELECTEDVALUE ( 'Table'[Type] ) = "Non Preventable"
        && [Difference] < 18,
    "Yes",
    IF (SELECTEDVALUE ( 'Table'[Last Collision Date] ) = BLANK ()
            && SELECTEDVALUE ( 'Table'[Type] ) = "Preventable",
        "Yes",
        "No"
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, taskinosurname 

 

You can try the following methods.
Sample data:

Measure:

Difference = IF(SELECTEDVALUE('Table'[Last Collision Date])=BLANK(),0,
ABS (DATEDIFF (SELECTEDVALUE ( 'Table'[Date] ),
              SELECTEDVALUE ( 'Table'[Last Collision Date] ),MONTH)))
Retraining Req'd = 
IF (SELECTEDVALUE ( 'Table'[Last Collision Date] ) <> BLANK ()
        && SELECTEDVALUE ( 'Table'[Type] ) = "Non Preventable"
        && [Difference] < 18,
    "Yes",
    IF (SELECTEDVALUE ( 'Table'[Last Collision Date] ) = BLANK ()
            && SELECTEDVALUE ( 'Table'[Type] ) = "Preventable",
        "Yes",
        "No"
    )
)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • taskinosurname's avatar
    taskinosurname
    Frequent Visitor
    3 years ago

    Thanks a million. This is what I was looking for. Given that I'm still relatively a novice with DAX, I would've never thought to put a measure within a measure. Thanks again.

     

    Warm regards,

     

    Taski