Countif as a function in M - Power Query

---

rafaelsmoreno wrote:

... 

Base_documentos is the query in which I am running the code. Is that a problem? Should I place instead of Base_documentos the previous stage of the query?

 ...

 

 

 

---

Yes, that's causing the circular dependency error. 

As you said: Take the previous step name instead.

Actually: You should take the buffered previous step name: 

let

...

#"Personalização Adicionada3" = Table.AddColumn(#"Índice Adicionado","contCHAVE", each fcountif(Table.Buffer(PreviousStepName), "CHAVE", [Índice])),
#"Personalização Adicionada4" = Table.AddColumn(#"Personalização Adicionada3","contCHAVEOR", each fcountif(Table.Buffer(PreviousStepName), "CHAVEOR", [Índice]))

in
#"Personalização Adicionada4"

Thanks for the follow ;)