Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Replicate countif excel function in PowerQuery

Hi,   I'm trying to replicate countif excel function into powerquery. =COUNTIF(C:C,C3)   End result should be as below Item Count of Items A 4 A 4 A 4 A 4 B 4 B 4 ...
Need Help
Show and Tell
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    =let a=Table.Buffer(Table.Group(PreviousStepName,"Item",{"n",Table.RowCount})) in Table.AddColumn(PreviousStepName,"Count of Items",each a{[Item=[Item]]}[n])

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

=let a=Table.Buffer(Table.Group(PreviousStepName,"Item",{"n",Table.RowCount})) in Table.AddColumn(PreviousStepName,"Count of Items",each a{[Item=[Item]]}[n])