Ayuda Countif

[Donalson]

Estimados señores,

En Excel nosotros tenemos la formula countif, como usamos esta formula en la tabla de BI?

Me gustaria contar los valores repetidos en la tabla de forma ascendente de acuerdo a su ubicación: ej:

Countif (A$1:A2;A2), donde la columna "A" = "Nombre"

[v-jingzhang · Accepted solution]

Hi @Donalson 

If you want an M solution, you can add a custom column with below code in Power Query Editor:

let _name = [Name] in List.Count(List.Select(#"Previous Step"[Name], each _ = _name))

If you want a DAX solution, you can add a new column in Power BI Desktop

Column = CALCULATE(COUNT('Table'[Name]))

Or

Column 2 = COUNTROWS(FILTER('Table','Table'[Name]=EARLIER('Table'[Name])))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Vijay_A_Verma]

The equivalent formulas will have to be made through List functions. But we need to see your sample data and illustrated result from that sample data to give you a formula.