"Translate" from MS Excel "IF" & "AND" to PBI DAX required

[Orstenpowers]

Dear all,

I wrote an Excel formula that works perfectly fine, but now I do need to transfer it to PBI, writing a new measure, but my attempts by using IF, AND and SELECTEDVALUE do not work. ☹️

Is anybody out there who could "translate" the following Excel formula?

=IF(AND('IObOL new (incl K Group)'[GID (Final Ship to)]= 'IObOL new (incl K Group)'[GID]; 'IObOL new (incl K Group)'[GID (Final Ship to)]= 'IObOL new (incl K Group)'[GID (Final Sold to)];"alle GIDs identisch";

IF('IObOL new (incl K Group)'[GID]= 'IObOL new (incl K Group)'[GID (Final Sold to)];"Order und Sold to identisch";

IF('IObOL new (incl K Group)'[GID (Final Ship to)]= 'IObOL new (incl K Group)'[GID (Sold to)];"Final ship to und Sold to identisch";

IF('IObOL new (incl K Group)'[GID (Final Ship to)]= 'IObOL new (incl K Group)'[GID];"Final ship to und Order identisch";"alle GIDs unterschiedlich"))))

I do not get managed. Hopefully one of you can help me.

[DataInsights · Accepted solution]

@Orstenpowers,

Try this measure. I wrapped each column reference in MAX (MIN would work too). If you want this to be a calculated column, remove MAX. A calculated column has the advantage of enabling you to filter on the resulting value.

Measure =
SWITCH (
    TRUE,
    MAX ( 'IObOL new (incl K Group)'[GID (Final Ship to)] )
        = MAX ( 'IObOL new (incl K Group)'[GID] )
        && MAX ( 'IObOL new (incl K Group)'[GID (Final Ship to)] )
            = MAX ( 'IObOL new (incl K Group)'[GID (Final Sold to)] ), "alle GIDs identisch",
    MAX ( 'IObOL new (incl K Group)'[GID] )
        = MAX ( 'IObOL new (incl K Group)'[GID (Final Sold to)] ), "Order und Sold to identisch",
    MAX ( 'IObOL new (incl K Group)'[GID (Final Ship to)] )
        = MAX ( 'IObOL new (incl K Group)'[GID (Sold to)] ), "Final ship to und Sold to identisch",
    MAX ( 'IObOL new (incl K Group)'[GID (Final Ship to)] )
        = MAX ( 'IObOL new (incl K Group)'[GID] ), "Final ship to und Order identisch",
    "alle GIDs unterschiedlich"
)

[Orstenpowers]

@DataInsights : Thank you so much! It works absolutely fine. 👍