Power Query - Count specific item in a column | Excel forum

Resolved · Medium Priority · Version 2016

Wed 24 Feb 2021, 17:07 Delegate Kay said...

Kay has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course

Power Query - Count specific item in a column

Hi,

I am trying to produce a report in Power Query to count a value. I have a table with this information

I would like to implement a "Count" excel function in Power Query to count and transfer directly to the report without having to write formulas to transfer the value every month.

For example.

I have raw data that produces a value in column Y that is reported each month, e.g Jan, Feb, Mar and so on.

the only way I've found is by using VLOOKUP to do this however would like to know if there is a better way to do this. Any help will be greatly appreciated

Wed 24 Feb 2021, 17:59 Trainer Jens said...

RE: Power Query - Count specific item in a column

Hi Kay,

Thank you for the forum question.

I am sorry but it is not clear to me what you want.

"I am trying to produce a report in Power Query to count a value. I have a table with this information"

Do you mean that you like a countif want to count specific criteria you have listed in a table? You can add any number of calculated columns in Power Query. You can also write Power Query M codes to code it.

I will need more details to help you.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 24 Feb 2021, 18:04 Delegate Kay said...

RE: Power Query - Count specific item in a column

Hi Jen,

Many Thanks for coming back to me.

Would it be easier if I sent you my data sheet for you to see what details I am trying to extract

Please share an email so I can send it across to you now.

Many thanks

Wed 24 Feb 2021, 18:12 Trainer Jens said...

RE: Power Query - Count specific item in a column

Hi Kay,

You can send the data to:

info@stl-training.co.uk

Then our office will send it to me tomorrow. Please type to Jens in the subject. And please add more details so I know what you want to achieve.

Thanks

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 24 Feb 2021, 19:30 Delegate Kay said...

RE: Power Query - Count specific item in a column

Many Thanks Jen.

I have sent the data to the email address as requested.

Thu 25 Feb 2021, 13:13 Trainer Jens said...

RE: Power Query - Count specific item in a column

Hi Kay,

I have sent you an email with a solution. When you refresh the query your report automatically add future months and do the count.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector