Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |