Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

variable + if stament

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 🙂
 

 

 

Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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