topic Re: IF in DAX Studio in DAX Commands and Tips

IF in DAX Studio

Anonymous — Fri, 21 Apr 2023 18:37:27 GMT

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(VALIDATED_PD[f_Category_1290] = "GM","GM",VALIDATED_PD[d_Customer_Name])

EVALUATE
ADDCOLUMNS(
VALUES( VALIDATED_PD[m_Group_Currency_Amount] ),
"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])
)

Re: IF in DAX Studio

Jihwan_Kim — Fri, 21 Apr 2023 21:01:09 GMT

Hi,

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

Re: IF in DAX Studio

Anonymous — Fri, 21 Apr 2023 21:25:13 GMT

Is it possible to add more than one IF? for example add to the same code (last part of the code) (Code in DAX Studio is still running for last code)

f_GM/CustomerNo = IF(VALIDATED_PD[f_GM/Customer] = "GM", BLANK(), VALIDATED_PD[m_Customer_Number])

Re: IF in DAX Studio

Jihwan_Kim — Fri, 21 Apr 2023 21:31:48 GMT

Hi,

Please share your sample pbix file's link with how your expected outcome looks like.

Thanks.

Re: IF in DAX Studio

Anonymous — Fri, 21 Apr 2023 21:35:42 GMT

Hi, I cant share the data but this the code I have

In bold is the part that I am trying to add, above is the suggestion you made

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 )
    )

And this the error:

Re: IF in DAX Studio

Anonymous — Fri, 21 Apr 2023 21:35:44 GMT

Hi, I cant share the data but this the code I have

In bold is the part that I am trying to add, above is the suggestion you made

And this the error:

Re: IF in DAX Studio

Jihwan_Kim — Fri, 21 Apr 2023 21:49:03 GMT

Hi,

Sorry, this does not help to understand what/how is your expected outcome.
Please try something like below.

EVALUATE table = ADDCOLUMNS ( SUMMARIZE ( VALIDATED_PD, VALIDATED_PD[m_Group_Currency_Amount], VALIDATED_PD[d_Customer_Name], VALIDATED_PD[m_Customer_Number] ), "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 ) )

Re: IF in DAX Studio

jiaopengzi — Sat, 22 Apr 2023 02:18:00 GMT

First make sure your business logic is correct.
1 Does your table `validated_pd` exist?
2 If your table exists, then your same [d_Customer_Name] will be allocated different [m_Group_Currency_Amount]
3 If the second item is satisfied, then you should still lack product information, or Say your "GM" needs to be distinct.

Re: IF in DAX Studio

Anonymous — Mon, 24 Apr 2023 14:31:16 GMT

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