Convert Excel formula

[Anonymous]

Hi, I am trying to recreate the above formula in DAX/BI.

I am a bit of a novice but i am hoping someone can help me understand why I can't get this to work.

I have imported "Product List" into BI and have a document that contains the product code that I am trying to link to.

Would appreciate any guidance please.

Thank,

Glen

[v-angzheng-msft · Accepted solution]

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.