Error using if condition

Hi,

Please try this Calculated Column

Column =
SWITCH (
    TRUE (),
    Procurementdata[Transaction Amount] >= 25000001, ">$25M",
    Procurementdata[Transaction Amount] >= 100000000
        && Procurementdata[Transaction Amount] <= 25000000, "$10M - $25M",
    Procurementdata[Transaction Amount] < 10000000, "<$10M"
)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)