Відео

Super helpful. I'd never used Power Query before.

In power query there is a remove rows feature. How does it decide what rows to cut? In excel under data if you did a remove duplicates it would leave the top entry and all subsequent dupes would be removed. I’m not seeing this same functionality in the remove rows. Regardless of how I sort prior to remove rows the removal seems random.

Thank you, brief and to the point and it resolves my issues. Have added my subscription!

How can you do it for phone numbers?

thanks a lot, i always hated this vlookup function

Thanks. I want to remove duplicates based on one column if the other column is grouped

Can you see what is wrong with this custom column? There is no if function as all I need to do is create a string which has two of the columns embedded. "schtasks /change /ENABLE /tn " + [TaskName] + " /s " + [Server]

Great video on merging/matching 2 columns! I have a scenario where the output depends on 6 column matches between 2 tables. How would you recommend I do this?

How can I do replace for different values for example M and D Should be replaced as Male.

I am trying this to sum overtime sheets containing duplicated dates. Thanks.

opened a 4th chakra in my brain and I finally managed to do what I wanted to after 2h of struggle, thank you sir

in append example when i refresh it duplicates my queries any help with solution ??????? t...

Awesome...How about adding email id in new column rather than separating it through ;? Also how about if we have numbers & not text?

This was extremely helpful as I had duplicate contact emails and didn’t want to lose any. I also have numbers I’m trying to combine but Text.Combine doesn’t work on numerical values. Any tips?

I have a similar example and did the exact same thing as you and removed duplicates, but after closing power query I get an error “[DataFormatError] We couldn’t convert to Number”. How do you fix this?

nice

Awesome! Using that trick to fool PQ into summing Emails then edit the code. Glad to subscribe. 👏

Graaacias me ayudaste un montón!

Thanks, this was really helpful! Subscribed

Is there a way to add a new source of data, but have the query "bypass" any row that would cause a duplicate?

Why not select only the row column?

Why is it bold

I was searching for this almost for a week.Thank You

What we can do if we find duplicates after the power query merges the Excel data?

Thank you. How would I rather than combine but put the 2nd email into another column under the same name/row? john doe(row 1), $xxxx (column b) $xxx (column c) john doe (row 2), $xoxoxo (column b), $oyoyoy (column c) I want to move row 2 (because it is the same name), column b & C up to column D & E row 1. I have hundreds of rows some have two or more duplicate names. I am trying to create a mail merge to send out email payment reminders and only want to send one email with all their payments listed. Thanks.

Thank you :))))

Thanks

It works! Thank you

This was great...thank you so much!

Hi, i have an issue though, what if i want all the names merged as one name and then emails as one email, considering that my data has the same name and emails, the name on the left and mails on the right but some names are not paired to their mails,but are paired to their mails as u scroll down. I don’t know if my explanation is clear enough. Thanks

What if you want to do the same but instead of different emails, its client ID numbers? Is there a different code I can use?

Is it possible to have a cell that tallies the total of all amounts in a column in which another column in that row has a letter entry? For example, if you have a row in a finance table, with venue, date, amount and method (C-cash, V=credit card and P=Paypal) columns, then cell H7 would equal all the amounts in the column in which that letter is in the method column? LIke "=total of amounts in amount column in which method column = C?

This is awesome, thanks! What about if you have multiple duplicates, like email addresses AND phone numbers?

Excellent video well explained, I appreciate that Paolo!

good knowledge

Pls make a video in power bi desktop power query if we have 2 tables and i need only the date column from other table, but while performing merge my dataset is getting duplicated. When i hav many to many in both the tables how to perform merge.

Thank you soo much

Very helpful indeed.... Thanks alot.

You're the only one who made this clear! Thanks!

Hello. But how can I remove duplicates from only 1 column?

Nice but Texas isn't a City

Hi Paolo, thanks for very well explained tutorial. Using Vlookup you can map a score to a letter grade by ensuring the lookup table is sorted and leveraging non-exact match. How do you achieve the same look up results using merge in Power Query? Assuming u have table with upper and lower bounds columns and a letter grade column. Thanks

Great vid! I imagine this can also be done same way in Power BI. Would this work with a date filter/slicer so you could see the sum of a fruit for say, Jan-Mar that would change if the data slicer selected Jan-Apr?

This video very helpful. Thank you!

Very helpful video! Thank you for sharing your experience with Excel and Power Query. Look forward to your next video.

nice one bro,subs

I never heard of the indirect function. This was very interesting. I subscribed!

Thanks for watching! Subscribe for more Excel/Power Query tutorials. Also, what video should I make next?

Good video 👍

that was amazing.