Forum Discussion
Anonymous
7 years agoNot applicable
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