Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Icon for Helper V rankHelper V
5 years ago
Solved

Multiple and's in a calculated column

Hi,   I have a dataset where i want to classify each row based on a few criteria.  If Customer previously exists in the data AND the customer has signed a contract  Then "value1"   How do i wr...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi CarlsBerg999 ,

     

    According to your judgment, I did the following test:

    M =
VAR cur_id =
    MAX ( Table1[Customer ID] )
RETURN
    IF (
        MAX ( Table1[LAST_status] ) = 1
            && MAX ( Table2[Customer] ) = cur_id,
        "old customer",
        "new customer"
    )

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

     

    Best Regards,
    Henry

     

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

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi CarlsBerg999 ,

 

According to your judgment, I did the following test:

M =
VAR cur_id =
    MAX ( Table1[Customer ID] )
RETURN
    IF (
        MAX ( Table1[LAST_status] ) = 1
            && MAX ( Table2[Customer] ) = cur_id,
        "old customer",
        "new customer"
    )

 


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

 

Best Regards,
Henry

 

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