Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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"
)
Proud to be a Super User!
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"
)
Proud to be a Super User!