Forum Discussion

Donalson's avatar
Donalson
Regular Visitor
4 years ago
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...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

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.