Forum Discussion

luizahenriques's avatar
luizahenriques
Frequent Visitor
3 years ago

CONTAINS with virtual tables

I need to use CONTAINS using virtual tables but I don't the better way.

This measure must return TRUE of FALSE if the column "Primeiros Caracteres" of  table f_Ciclo (with actived relationship between f_Ciclo(Ciclo) e dCicloAnterior(Ciclo)) is contained in column "Primeiros Caracteres" of  table f_Ciclo ((with actived relationship between f_Ciclo(Ciclo) e dCicloAtual(Ciclo)).

 

In other words, i need to use CONTAINS but with the same table (with different filters). I don't know to do it without to use virtual tables. But CONTAINS doesn't support it.

 

Can you help me, please?

Need Help

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    Hi luizahenriques 

    Thanks for reaching out to us.

    I'd like to help you, but there's no sample data.  could you share some sample data or .pbix file and the expected output? thanks.

     

     

    Best Regards,

    Community Support Team _Tang

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