Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!