98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Power Query - Count specific item in a column | Excel forum
Power Query - Count specific item in a column | Excel forum
Resolved · Medium Priority · Version 2016
Wed 24 Feb 2021, 17:07Delegate 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:59Trainer 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:04Delegate 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:12Trainer 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:30Delegate 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:13Trainer 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
Thu 4 Mar 2021: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Paste functions box quicklyIf you want to do a formula using the paste functions box press SHIFT + F3. |
