Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to create a custom column with below formula in power query.
MODE = IF(OR('Final'[A]>100,'Final'[B]>112 || 'Final'[C]>70),"FTL","LTL")
Solved! Go to Solution.
Hi @Anonymous ,
Try this:
if [A] > 100 or ([B] > 112 or [C] > 70) then "FTL" else "LTL"
Pete
Proud to be a Datanaut!
Hi @Anonymous ,
Try this:
if [A] > 100 or ([B] > 112 or [C] > 70) then "FTL" else "LTL"
Pete
Proud to be a Datanaut!