Convert Excel formula

Hi, Anonymous 
Try this:

Column =
IF(
    CALCULATE(
        MAX( 'table'[E] ),
        FILTER( ALL( 'table' ), [B] = "*" & [F] & "*" )
    ) = "generally available",
    SWITCH(
        TRUE(),
        [R] = "BTL", "BTL",
        [T] <= 0.8, "Standard Low LTV",
        [T] > 0.8, "Standard High LTV"
    ),
    CALCULATE(
        MAX( 'table'[E] ),
        FILTER( ALL( 'table' ), [B] = "*" & [F] & "*" )
    )
)

If this does not solve your problem, could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.