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])

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

Is that a mistake on the B rows?

If I understand correctly, you can do it like this:

Do a 'Group By' with only 'All Rows'

Then add a custom Column using Table.RowCount on the column that the previous step created.

Expand the rows. That's it.