Forum Discussion

JDB79's avatar
JDB79
Copper Contributor
Jul 10, 2021
Solved

Power Query: COUNTIFS

Hello, I am struggling to achieve below CountIfs-Formula in PowerQuery.  Any suggestions would be highly welcome! Thank you JDB79    
BI & Data Analysis
excel
power bi
  • JDB79's avatar
    JDB79
    Jul 10, 2021

    SergeiBaklan 

    Hello, 

    Many thanks. Yes, this will work for me.

     

    Thank you.

     

    JDB79

     

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jul 10, 2021

JDB79 

I'm certainly not the most suitable to submit a suggestion to you, but I'll give myself a try :).

Here is a small example .

 

would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

 

  • JDB79's avatar
    JDB79
    Copper Contributor
    Jul 10, 2021
    Hallo,
    Vielen Dank für die Mühe. Problem ist für mich gelöst.
    🙂
    P.S. Bin sogar auf eine weitere Lösung gestoßen:
    https://stackoverflow.com/questions/53305097/countifs-equivalent-in-power-query-m-counts-per-row-within-self

    Problem ist für mich gelöst.

Resources