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

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    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

    I got it

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Have in (Consulta2[COD_EQPMT_PRODC]) but Dados RELATED with Consulta1 . And Consulta1 RELATED with Consulta2 .

    Consulta2 not RELATED with Dados.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    It's working, thanks.

    You helped me a lot.

    But as I do add more   Dados[NOM_ABREV] = "305"  Dados[NOM_ABREV] = "306" Dados[NOM_ABREV] = "307" up to 320.
    And each "304" "305" "306" "307" has different specifications