contar.si en power bi

[eaburto2019]

hola, comunidad

requiero su apoyo con este tema:

tengo 2 hojas en excel (base1 y base2)

estoy en base 2 y deseo buscar los registros que estan en base 1. esto en excel lo resolvi con: =+SI.ERROR(SI(COINCIDIR(A2;base!G:G;0);"OK");"POR DEFINIR")

lo que se busca en que en power bi donde estas 2 tablas estan cargadas crear una columna en base 2, en esta columna realizar este calculo. que funcion puedo usar?

gracias por su apoyo.

saludos,

Edison

[Nathaniel_C]

@eaburto2019 ,

Google trans to English to open your possible audience of helpers. Not sure on the Excel part.

hello community

I require your support with this topic:

I have 2 sheets in Excel (base1 and base2)

I am in base 2 and I want to look for the records that are in base 1. This in excel solved it with: = + YES.ERROR (YES (MATCH (A2; base! G: G; 0); "OK"); "BY DEFINE")

what is sought in that in power bi where these 2 tables are loaded create a column in base 2, in this column perform this calculation. What function can I use?

thanks for your support.

regards,

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel