Forum Discussion
Solved
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...
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.
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.