Forum Discussion
Ayuda Countif
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"
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.
2 Replies
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.
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.
