Forum Discussion

lmcpinto's avatar
lmcpinto
Frequent Visitor
3 years ago
Solved

Calculated column

Hello everyone, I have a doubt.

I need the following, if column 3 has event "Envio de Comunicação", then in column Is Comunicação, it should appear "Envio de Comunicação" for all the ids that have the event happening.

 

For example, id 1 should have "Envio de Comunicação" in both rows instead of only having when column 3 is "Envio de Comunicação". Once the event happens, all the corresponding ids should have "Envio ..." Or " Não envio...:"

 

Thank you in advance!

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi lmcpinto ,

     

    You can create a calculated column by below code.

    Is Comunicação =
VAR _LIST =
    CALCULATETABLE (
        VALUES ( 'Table'[Column3] ),
        ALLEXCEPT ( 'Table', 'Table'[Column1] )
    )
RETURN
    IF (
        "Envio de Comunicação" IN _LIST,
        "Envio de Comunicação",
        " Não Envio de Comunicação"
    )

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi lmcpinto ,

     

    You can create a calculated column by below code.

    Is Comunicação =
VAR _LIST =
    CALCULATETABLE (
        VALUES ( 'Table'[Column3] ),
        ALLEXCEPT ( 'Table', 'Table'[Column1] )
    )
RETURN
    IF (
        "Envio de Comunicação" IN _LIST,
        "Envio de Comunicação",
        " Não Envio de Comunicação"
    )

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.