Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

IF in DAX Studio

Hi I am trying to create a formula in DAX with IF but I keep getting errors in the bold area, can someone tell me what I am doing wrong?   This is what I am trying to create f_GM/Customer = If(VA...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure if I understood your question correctly, but please try something like below.

 

EVALUATE
    ADDCOLUMNS (
        SUMMARIZE (
            VALIDATED_PD,
            VALIDATED_PD[m_Group_Currency_Amount],
            VALIDATED_PD[d_Customer_Name]
        ),
        "Total Overdue", [a_TotalOverdue],
        "Customer Name",
            VAR f_GM_CustomerPD = VALIDATED_PD[d_Customer_Name]
            RETURN
                IF ( f_GM_CustomerPD = "GM", "GM", VALIDATED_PD[d_Customer_Name] )
    )
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I have this but the bold part doesn't work the "Customer Number" column, the rest does 

 

EVALUATE
    ADDCOLUMNS (
        SUMMARIZE (
            VALIDATED_PD,
            VALIDATED_PD[m_Group_Currency_Amount],
            VALIDATED_PD[d_Customer_Name]
        ),
        "Total Overdue", [a_TotalOverdue],
        "Customer Name",
            VAR f_GM_CustomerPD = VALIDATED_PD[d_Customer_Name]
            RETURN
                IF ( f_GM_CustomerPD = "GM", "GM", VALIDATED_PD[d_Customer_Name] ),
        "Customer Number",
            VAR f_GM_CustomerPD = VALIDATED_PD[d_Customer_Name]
            VAR f_GM_CustomerNumber = VALIDATED_PD[m_Customer_Number]
            RETURN
                IF ( f_GM_CustomerPD = "GM", BLANK(), f_GM_CustomerNumber )       
    )