Forum Discussion

ROG's avatar
ROG
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Dax measures help need

Hi all,   I posted a question here this morning but I didn't get the full solution, so I thought I would post here where I got stuck at.  I want to add a new column saying 'Customer type change?...
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ROG ,

    Please try below options:

    My test table:

    ProductAcquisition:

    CustomerType:

    Model:

     

    Try below DAX to add new column in table ProductAcquisition:

    CurrentCustType_FromCT = RELATED(CustomerType[CurrentCustType])
    Column = if([First_CustType]= [CurrentCustType_FromCT],1,0)

     

    Best regards,

    Community Support Team_ Binbin Yu

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ROG ,

Please try below options:

My test table:

ProductAcquisition:

CustomerType:

Model:

 

Try below DAX to add new column in table ProductAcquisition:

CurrentCustType_FromCT = RELATED(CustomerType[CurrentCustType])
Column = if([First_CustType]= [CurrentCustType_FromCT],1,0)

 

Best regards,

Community Support Team_ Binbin Yu

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