Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Logical Conditions

Hi, i need some logical conditions, but i don't know hot to make it (syntax).     I need > IF (Dados[NOM_ABERV]) = "304" and (Dados[COD_EQPMT]) ="AOD" and RELATED(Consulta1[COD_TIPO_PRCES])=" F-F ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Try this formula, please.

    Column 1 = 
VAR COD_TIPO_PRCES =
    RELATED ( Consulta1[COD_TIPO_PRCES] )
VAR c =
    RELATED ( Consulta1[C] )
RETURN
    IF (
        Dados[NOM_ABREV] = "304"
            && CALCULATE(min('Consulta2'[COD_EQPMT_PRODC])) = "AOD" ,
        SWITCH (
            TRUE (),
            COD_TIPO_PRCES = "F-F"
                && ( c < 3.5
                || c > 7 ), "not",
            COD_TIPO_PRCES = "F-P"
                && ( c < 4
                || c > 7 ), "not",
           "yes"
        ),
        BLANK()
    )

    result

     

    Best Regards,

    Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-jiascu-msft Hi,

This error has been corrected, but the return BLANK column and only the last two rows have (C <3.5 OR C> 7) should return "NOT" and the others as they should return "YES".

If you need I can send you a copy of my project.

Thanks so much !


 

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Please share the file. That would be the fast way to solve this issue. 

If you can make it public, please paste the download link here.

If you can't, please send me a private message through Message.

Anyway, please mask or delete the confidential parts.

 

Best Regards,

Dale

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous,

       

      This link needs permission. I have clicked Request. Please kindly approve. It's dalet****@gmail.com.

       

       

      Best Regards,

      Dale

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous,

         

        There aren't any "AOD" in column Dados[COD_EQPMT]. That's why it's empty. You can see the result in the Data tab. 

        Please add more details or delete this condition.

        Logical_Conditions

         

         

        Best Regards,

        Dale