cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

## Ayuda con Formula if y countif arrastrado

Tengo el siguiente detalle, quisiera saber pasar una formula de excel a power query

 Naturaleza Cedula Cantidad de Registros Duplicados 1=se elimina0=no se elimina positivo 18.75-positivo 0.00 0.00 positivo 25.8-positivo 0.00 0.00 positivo 40-positivo 2.00 1.00 positivo 5-positivo 35.00 1.00 positivo 61-positivo 0.00 0.00 positivo 4.55-positivo 0.00 0.00 positivo 51.1-positivo 0.00 0.00 positivo 5-positivo 35.00 1.00

la formula de la ultima columna es la siguiente:

=+IF(Q2="negativo",IF(COUNTIF(R\$2:\$S2,R2)<=S2,1,0),IF(COUNTIF(R\$2:\$S2,R2)<=S2,1,0))

he podido replicar lo del if con una columna condicional pero aun no se como logar la parte del COUNTIF(R\$2:\$S2,R2) donde tomo como rango unicamente los valores arriba de la fila en la que voy

espero me puedan ayudar

Saludos

Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors