Forum Discussion

Stuk's avatar
Stuk
Helper I
9 years ago

help Dax formula

hello ! i have a problem with two dax formula but i can't get why can you help me  ?

Need Help

3 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi Stuk,

     

    #1. For the first DAX, "||" is a DAX logical operator: Logical Operators. It seems that you return the results based on two columns: [Statut envoi] and [Statut RDV], right? What's the logic do you want to return results?

     

    If only based one column, you can use nested IF() function or use the Switch() function refer to this article: DAX – Making the “Case” for SWITCH().

    If based on two columns, you can use nested columns like below:

     

    Column = IF('DimSalesTerritory'[SalesTerritoryGroup]="Europe" || 'DimSalesTerritory'[SalesTerritoryKey]=6,"c",IF('DimSalesTerritory'[SalesTerritoryGroup]="Europe" || 'DimSalesTerritory'[SalesTerritoryKey]=1,"k",Blank()))

     

    #2. Regarding the second DAX, you can check the data type of [Retenu], if it's number data type, please change "0" to 0. 

     

    If issue persist, please share some sample data regarding those two DAX, explain to logic to get desired results for your analysis.

     

    Best Regards,
    Qiuyun Yu

     

     

     

     

    • Stuk's avatar
      Stuk
      Helper I
      9 years ago

      Hi v-qiuyu-msft first thanks for your help i want to make a column which could say " if  in 'Suivis fusionnés'[Statut envoi],  "Perdu/CV" is written then  write "Perdu / CV" but i need to do it for Suivi fusionnés[statut envoi] column and Suivis fusionnés'[Statut RDV] column so the best could be to merged IF('Suivis fusionnés'[Statut envoi] = "Perdu/CV"; "Perdu / CV";BLANK()); and Switch('Suivis fusionnés'[Statut RDV]; "Perdu/RDV";"Perdu / RDV"; "Recruté, pas venu"; "Recruté, pas venu";"Refus propale";"Refus propale";BLANK()) for the first one 
      for the second one Retenu is made of N ( for No ) and O (for Yes "Oui" in my tongue)