Calculated column

[lmcpinto]

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!

[Anonymous · Accepted solution]

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.

[lmcpinto]

Thank you!!!!!