Count Occurrence Or Add Index Number To Group Data | Power Query & PowerBI

Learn for Power Query & PowerBI, How to count the number of occurrences also explains how can we add the index number to the grouped data

00:00 Intro
00:20 Understanding the Data Set
01:10 Loading Data Into Power Query
01:35 Enable Formula Bar In Power Query
02:40 Count the Occurrences Formula
05:10 Adding New Data
05:40 End

👍🏻 Like us on Facebook

👥Join The Facebook Group -
***********************************************************
You can check the following videos as well
🛠 Handling 📅 Date & Time ⏳ In Excel (PART 02) ‼️
—————————————————————
🔍Find The Missing Data Based Header Text - PowerQuery
—————————————————————
🔍Simple way of using Index & Match explain in detail.
—————————————————————
💡Tip & Trick: Automatically insert decimal point upon entering values (Mac & Windows)
—————————————————————
🔧How To Install Power Query For Excel 2010 & 2013
***********************************************************
#PowerQuery #PowerBI #MicrosoftCreators #ProductivityHack

[OzduSoleilDATA]

I like it! That's a tough challenge to solve.
And I saw those balloons! :)
😄

[pravinshingadia]

My friend - this is brilliant. Thank you - you helped me with problem today

[tayedawa]

Fantastic! I have been searching this for hours and it could be days if I had not bumped into this video! Thank you Sir!

[subhassamuel]

very useful simple and great, God bless you brother

[reginaldbal]

Very clear explanation. I was wondering if you might be able to explain how to adapt following additional requirement: when starting a new group I'd like to have the index to continue rather than being reset.

[pratikfutane]

That's really awesome!! I was able to achieve the same requirement in Power BI using your steps. Thanks a Lot!!

[marcinczajkowski]

Love the solution - thank you so much for sharing

[angieburnikel]

This is SO helpful. Thank you so much for posting this!

[marcosvincius]

Thanks for helping me, now i can do my job easily

[karthiksn]

This is an alternative way for using the countif formula in the power quarry.. Thanks a lot

[tomaszs]

Thank you so much, Faraz. That's extremely helpful!

[anthonygikuri]

Thank you for your time. What if I want power query to generate steps that sum up the distinct rows... Can you help please. For instance, I want the sum of Smart TV instead of having the item repaeted twice or more

[YasirFarooq-jjyv]

Can we do same thing for calculated columns in DAX?

[swindonwellness]

Been looking for a solution to this since yesterday, so glad I found this - thank you sir!

[leonardocastro]

THANK YOU SO MUCH YOU SAVED MY LIFE PLEASE COM TO BRAZIL SO I CAN HUG YOU

[AndresDehayes]

How would I return a count for the number of instances? Let's say I only want to know how many times each product occurs in the dataset, how would I only view those numbers?

[manishanegi]

Please advise, if instead of occurrence, I want to bring the total occurrences in front of each occurrence, how could that be done? Example, if Headphone appears twice, the first occurrence would show1 and the second one will show 2. However, if I want to see 2 both the times how could that be done?

[entertainmentgalaxy]

Amazing trick. thanks for sharing PQ fun...

[DiwankarSingh]

what to do if i want to keep the same serial number for those data that are same in the column

[singhalmonica]

Thanks sir, pls guide me how can we have 1 for HeadPhone on each occurance.