variable + if stament

[Anonymous]

hello i'm trying to translate this python code into dax using variable 

def force(p😞
    if p["Zones_A"] == "4" and p["Zone_C"] == "4":
        return p["net"]
    elif p["Zones_A"] == "4" and p["Zone_C"] == "3":
        return p["CA_fid_CRF"]*mvt["Effet"][mvt["Mvt"]=="B-C"]
    elif p["Zones_futures"] == "4" and p["Zone_future_ap_reco"] == "2":
        return p["CA_fid_CRF"]*mvt["Effet"][mvt["Mvt"]=="B-D"]
    elif p["Zones_futures"] == "4" and p["Zone_future_ap_reco"] == "1":
        return p["CA_fid_CRF"]*mvt["Effet"][mvt["Mvt"]=="B-E"]
    elif p["Zones_futures"] == "4" and p["Zone_future_ap_reco"] == "0":
        return p["CA_fid_CRF"]*mvt["Effet"][mvt["Mvt"]=="B-NA"]
    elif p["Zones_futures"] == "3" and p["Zone_future_ap_reco"] == "4":
        return p["CA_fid_CRF"]*mvt["Effet"][mvt["Mvt"]=="C-B"]
    elif p["Zones_futures"] == "3" and p["Zone_future_ap_reco"] == "3":
        return p["gain_net"]

and what i'm trying to do with dax 

calcule_intensité =

var A = result[Zones_actuelles]

var B = result[Zones_futures]

var C = result[Zone_future_ap_reco]

var d = result[CA_fid_CRF]

var g = result[gain_net]

var Effet = result[Mvt_Force]

return

SWITCH(

IF( B= 4 && C=4,g,

IF(B = 4 && C = 3,CALCULATE(SUM(d)*SUM(result[Mvt_Force]=))))
but actually i'm lost, can someone help me please 🙂

[amitchandak · Accepted solution]

@Anonymous , You need to try Switch(True(),

example

SWITCH(true(),
search("Red",[column1],1,0)>0 || search("Green",[column1],1,0)>0 ,"C1"
search("Yellow",[column1],1,0)<0 , "C1",
blank()
)

Also, it can only one data type. so take care of that

[mahoneypat]

Please see this post on SWITCH(TRUE(), ... which would be best approach for your scenario.

https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat