Forum Discussion

rafaelsmoreno's avatar
rafaelsmoreno
Frequent Visitor
7 years ago
Solved

Countif as a function in M - Power Query

Hi   I am trying to create a function that would emulate the countif from excel into power query. I tried the code at this post below, but it is just not working for me.   https://community.power...
Need Help
  • ImkeF's avatar
    ImkeF
    7 years ago
    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 ;)

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi rafaelsmoreno,

 

Have you solved your problem?

 

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly. 

 

Best Regards,

Cherry