Forum Discussion
IF OR formula for custom column in power query
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")
Hi Anonymous ,
Try this:
if [A] > 100 or ([B] > 112 or [C] > 70) then "FTL" else "LTL"Pete
1 Reply
- BA_Pete
Super User
Hi Anonymous ,
Try this:
if [A] > 100 or ([B] > 112 or [C] > 70) then "FTL" else "LTL"Pete