Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

COUNTIFS power query ?

Hello everyone,

 

i really need your help about an issue which is HOW TO USE A COUNTIF FUNCTION ON POWER QUERY ?

i would like to create a measure like that :

 

=(COUNTIFS('Suivi collab N-1'!$F:$F;"Non";'Suivi collab N-1'!$W:$W;"Actif";'Suivi collab N-1'!$L:$L;"AUDIT";'Suivi collab N-1'!$CK:$CK;"Encadrement")

 

In power BI :

 

$W:$W = column "EST"
$W$W = column "statut"

$L$L = column "UG"

$CK:$CK = column "Managers"

 

I know to do that with ONE criteria for example : countrows(filter(Table1;Table[ColumnName]="CRITERIA"))

 

But how to do that with multiple criteria ?

 

I'm sorry for my bad english. I'm trying to do my best to be understood.

 

thank you a lot for you help !

 

 

No Replies